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

Question

Adding a value to Lookup Table

Forms Layout Designer

Updated November 6

asked on November 6

I have a drop-down menu that shows the values from a SQL table via Lookup Rules. Is it possible for a user to add a value to the SQL table if their value is not in the drop-down menu (SQL Table)?

0 0

Replies

replied on November 6

Hi Scott,

If you set the field up as a single line, it should allow the user to type in their own value if it's not in the SQL table. Then upon submission, you can have a workflow check to see if the submitted value is in the table and if not, it can insert a new row.

4 0

replied on November 6

That never would have occurred to me! Thank-you!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked November 6
Updated November 6
46 views