I'm working with a client and assisting with their data card, and I'm trying to link to a SQL Database. For some fields, I have no issues, as the SQL Query I'm using is pulling a single text field, and we're storing that text field in the SW Properties.
However, I have some fields have that a user friendly display name, and a database ID associated to it. I want to show the user the Display name, but store the ID.
I can do this with the 'Text with Alias' method, but, this leaves the list with static values. As new records are added to the SQL Database, it would appear I need to manually update the 'Text with Alias' list with the new data.
Is this the only method?
Has anyone found a hack/workaround that would allow the list to be updated automatically, on some frequency, pulling the new data from the tables as needed?
Thanks in advance,