Hello,
I am using the CList excell to show some options from a database. I was wondering if there was a way to store/show an Value and a Name (Text) for each option, instead of just a Value.
The reason is that I would like the grid data to save the ID of the database record(s) chosen, in case the name field value changes. If I create the CList using IDs, it’s not friendly for the editors to tell what each ID really means.
Does that make sense? For example, I would like to be able to do something like:
.registerCList(3, [‘Option1’,‘Option2’,‘Option3’], [1101,1102,1103]);
to associate ‘Option1’ with ID 1101, etc…in case Option1 changes in my database later. That way the user would see Option1 but 1101 would be stored. Similar to the way a regular HTML dropdown works (Option1).
Thanks,
Tom