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

Question

Question

Dynamic Field - Single field (just populate list from DB)

Forms
Updated October 27, 2015
asked on October 27, 2015 • Show version history

I am looking for a way to populate a list field from a SQL database dynamically. Is there a way to use External Tables so that the list field is only populated from a table with one column?

 

Edit: Nevermind. It is not a problem, you just have to use a template to access dynamic properties of a field. Then it allows you to just assign one field to one column.

0 0

Replies

replied on October 27, 2015

You can even point this at an external table (external from the database LF is using) if you setup a view pointing at the external db source. 

 

But yeah, it's template specific. The other gotcha is that if you have a workflow or other process that sets that field it can be something that is NOT on your external list. 

0 0
replied on October 27, 2015

I was wondering if views would work, I suppose you just enter the view name under table. I plan to have a view into Active Directory which ultimately syncs a list field with AD info. It will be cool.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...