I have a hardcoded list of statuses in my database. I created the status list below so that we "translate" the statuses into something meaningful to the client. Until last week these were static and non-configurable.
We have added a table to our database - it will only ever contain a single record so that our clients can add a single configurable status to their own databases. It can be whatever two letter code they want, and whatever description they want.
As a result, this newly configured status now needs to be added to the previously static list as a selector.
1) Is this even doable?
2) If so, how?
I have tried importing the record and then adding the two fields I imported into the listing but I get the name of the field as a string, not the contents of the field.
What am I missing? Anything to point me in the right direction would be appreciated!
Here is what I tried:
SQL SELECT *
load * inline [
'Current Booking Status', 'Booking Status Description'
Thank you SO much for your response! I think this would have worked, but I think I implemented it incorrectly. I am on my way out for the day so I am going to try it again tomorrow, purely for curiousity in case this comes up again in future!