AnsweredAssumed Answered

'Dynamic' Text with Alias on Data Card

Question asked by Total Eto Inc on Jul 24, 2019
Latest reply on Jul 27, 2019 by Ulf Stockburger

Hi folks,


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,