How often do the Data Sources sync?

SELECTED ANSWER

replied on November 21, 2016

To clarify, the lookup data itself is not "synced" at all with Forms; when a data source (e.g. external database) is added, Forms "becomes aware of" all of the tables, stored procedures, etc. that belong to the data source at that time. Refreshing a data source updates this internal list of the tables and stored procedures.

So if a table is used in a lookup rule, and you add data to that table, you don't need to refresh the data source. However if you add a table to an existing data source, you will need to refresh the data source before you can use that table in a lookup rule.

Hope this clears things up!

2 0

replied on November 22, 2016

I see, that makes perfect sense! Thank you!!

0 0

replied on December 14, 2018

That is a fantastic error, I recently created a process for users to update their own DB tables by uploading a CSV which runs a workflow that in turn runs a stored procedure to update the table. I was hoping I wouldn't have to refresh the data source which would prevent this automation from actually working as designed. But your answer clarifies my question as well!

Thanks!

0 0

Question

Question

How often do the Data Sources sync?

Answer

Replies

Sign in to reply to this post.