Question

In Forms, can you fill in a field from a database and also have the same field be a dropdown list?

Forms

Updated January 27, 2016

asked on January 26, 2016 • Show version history

In Forms, is it possible to have a field that is being auto populated from a database also be a dropdown list if the data that it pulls needs to be changed? Out of the box; it looks like you cannot do both. Is there any other way to accomplish this?

We have a Personnel Change Request Form. We pull data from our accounting software to auto populate a field; If that fields needs to be changed; we would like for them to erase what is in the field and pick from a drop down list. If we allow them to type it in; there is chance for error.

Any help would be greatly appreciated.

Judy Bunker

1 0

Replies

replied on January 26, 2016

Judy, not that I know of. If you are doing an initial lookup though you could have it populate a table row with the current information and add a field in the table called Status for whether that position needs to be dropped. Then you could allow the user to add additional rows that have a column that could be populated from the list for them to choose from and then change the status column to New. Similar to the following:

0 0

replied on January 26, 2016

Not out of the box, you can though with custom javascript. See this article. https://answers.laserfiche.com/questions/89039/Table-with-Dropdown-i-need-an-typeable-option

0 0

replied on January 26, 2016

Blake,

Here is a screenshot (fake information) On the left in the Employee and Position Information is the current information that is pulling from our SQL table; the employee is switching to a new position; they enter the new position number and the data is auto populated and displays on the right hand side. If any of the new information needs to be something different; I would like for them to erase that information and a drop down appear so they can pick the correct information and not have them type it in to avoid typos.

This will then go to the supervisor to see both Current and New Information to sign off on.

0 0

replied on January 27, 2016

Hi Judy,

Thank you for your use case. Currently it's not supported out of box in Forms. I'll bring it back to product team.

0 0

You are not allowed to follow up in this post.

Question

Question

In Forms, can you fill in a field from a database and also have the same field be a dropdown list?

Replies

Sign in to reply to this post.