You are viewing limited content. For full access, please sign in.

Question

Question

Keep Applicant From submitting More Than One of a Certain Form

asked on February 18, 2022

Hello Answers Community,

We have a Call For Artists form that will be going public soon and will be accepting only 60 applications.  I have the process figured out to number the applications (from 1 to 60) as they come in.  I am wanting to include a step that prevents an applicant from submitting more than one of these applications (as that will mess with my counting process).

I think I have seen something in Answers before, but cannot seem to locate it.

Any help would be great!

Thanks!

Christine

0 0

Replies

replied on February 18, 2022

You'll have to record who is filling them out in an external table and then use a lookup to alert them or disable submit if the lookup returns a row for that person already.

2 0
replied on February 22, 2022

Thanks Lexie,

Any examples of using a lookup to alert them?   I will keep looking on Answers, but if someone knows of a solution I could leverage from that would be great.

I already have the submit button hidden for other reasons.

Christine

0 0
replied on February 22, 2022 Show version history

Sure. It would require javascript to hide or show a Custom HTML field that contains a Warning Text (.warningText class).

Create a hidden field (.valueReturned class) that saves the value when hidden. Fill that hidden field with a value from your lookup table. Lookup the email address of the person filling out the form and maybe fill this field with their name or something. 

Show the warningText field when the hidden field is not empty.

$(document).ready (function () {

      $('.Submit').hide();
      $('.warningText').hide();

      $('.valueReturned input').change(hideWarningText);


      function hideWarningText() {
            var valueReturned = $('.valueReturned input').val();
            if (valueReturned != '') {
                  $('.Submit').hide();
                  $('.warningText').show();
            } else {
                  $('.Submit').show();
                  $('.warningText').hide();
        } //close else
      } //close function
}); //close docReady

I did not test this code. Just threw it together. It should give you an idea of what you'll need to do.

2 0
replied on February 22, 2022 Show version history

I currently ask the question "Is this your first submittal" and they manually answer yes or no.  If no, the whole form hides (with the exception of program overview info which contains a blurb about only submitting one entry etc).  If yes, they can proceed. 

I was hoping there was a way, with the lookup to answer the question for them, but don't see my radio button as something that can be autofilled if the last name and first name match on the lookup.

We are using 10.4.

 

0 0
replied on February 22, 2022

Thanks again Lexi!  I will give this a try!

Christine

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.