Populating reference control types via DataPortal Sync #59
-
|
Is there a way to populate a reference control type using DataPortal Sync? If so, what should the name of the column header be? Specifically if I do not have access to its primary key (ID), but another field (name) that is presumably unique. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
Yes, you can populate a reference control column via DataPortal Sync. The column header in your input table should match the column name in the DataPortal, and the values in the column should be the ID (primary key) of the object being referenced. In this case, since you don't already have access to the primary key, you'll want to |
Beta Was this translation helpful? Give feedback.
Yes, you can populate a reference control column via DataPortal Sync. The column header in your input table should match the column name in the DataPortal, and the values in the column should be the ID (primary key) of the object being referenced.
In this case, since you don't already have access to the primary key, you'll want to
JOINyour input data to the referenced table on your unique field before you perform the Sync.