Jump to content

Disallowed entries, popup warnings

Recommended Posts

So I am trying to limit a user from selecting an entry using an autocomplete (or I guess could be a dropdown).  This user entry field is using a column in a table as the source.  This is a complete list with all possible selections available (no replicates, and they are unique).  The user selects 3 selections on a weekly basis (Pick1, Pick2, Pick3) and the items are entered into the Pick table.  The catch is that the user CANNOT pick any of the previous selections from the previous week in the current submit week.  So I have created a formula in the Pick table to concatenate all 3 picks each week for a user into one field.  And I have been able to use this concatenated field in a RULE to at least warn the user that they are making an illegal choice.  However, I cannot remove the previous picks from the source table to make that not even available for selecting.  And I cannot prevent the user from still click the submit button (unless there is a way to implement a RULE to hide submit button until user fixes their selections...)


So I am wondering if there is a way to remove the previous picks from the users options to select.  These picks (text255 fields) also have an accompanying ID with them.  And these text values are also unique, I enforce this.


Example is the user is supposed to select 3 numbers from a table populated with the numbers 1 to 20.  They cannot select the same number in the same session.  So they select 1, 2, 3 in week 1.  Now in week #2, they can select ANY 3 numbers (no repeats again) EXCEPT 1, 2, 3.  So can the numbers 1, 2, 3 be removed from the dropdown (or autocomplete list) for just week 2.  They are legal choices in week 3, but now week 2's number selections are "illegal".  Each user will have the same situation, and the datapage is authenticated and I use the USERID.


Thanks in advance



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...