Question

Can you create a select list from a database table?

Administration

Updated February 13, 2018

asked on February 12, 2018

I can't seem to figure this out and I hope that is just the case. But, can you create a list field that is repopulated with a database table connection? I can only seem to find to type in what I want the list to be. I have figured out how to do dynamic lists but for this template it is just 1 field that we need the drop down for. There are thousands of clients in the list and would be ridiculous to type it all out.

0 0

Answer

SELECTED ANSWER

replied on February 13, 2018

You can have a single "dynamic" field. It will just read the data from your external table. It does not need to have child fields to populate based on its value.

2 0

Replies

replied on February 12, 2018

I think you're looking for dynamic fields?

0 0

replied on February 13, 2018 • Show version history

no, it is not dynamic fields. The field I want the select list for doesn't correlate with any other field in the template. We just want the select list for that one field.

unless you are saying we can create a dynamic field but not link it to any other fields in the template? Would that just be the parent field and thats it?

0 0

SELECTED ANSWER

replied on February 13, 2018

You can have a single "dynamic" field. It will just read the data from your external table. It does not need to have child fields to populate based on its value.

2 0

replied on February 13, 2018

Hi Casey.

Yes you can populate a field with any list or table you have in a SQL or MSSQL database.

It is very simple;

1.) Pull data/table/list into SQL

2.) Name it so that you know what it is

3.) Go to Forms - Top right click Forms -> Administration -> Data sources

4.) Add your SQL data source here

5.) Go to the form you want the list on

6.) Click on Lookup rules -> Add a rule and tell your field to fill only, remove the when condition.

Much more simple than it sounds.

Good luck, hope I helped.

0 0

replied on February 13, 2018

This is not using forms. This is just a template in the client.

1 0

You are not allowed to follow up in this post.

Question

Question

Can you create a select list from a database table?

Answer

Replies

Sign in to reply to this post.