Would like to have an extender field show a list of names to the user but save numeric IDs in the database
The Extender UI does show a list of the names to the User in a drop list (which is what i’m assuming you are referring to). And as you note, then it stores the selected item as a number in the table which references the extender tables and the list values for them.
That is why if your admin does change a name (to fix a typo perhaps) that way it doesn’t break your existing data and would immediately show that as the value.
Ah. I see what you mean. Perhaps I am not referencing my database tables correctly. Are there any queries / custom view build to deal with the extender tables, to help validate and trouble shoot? This is going to be tricky if moving data from one company to the next, isn’t it?
And depending how you are moving the data – maybe. If just in SQL then yes you’d have to be careful.
Thanks for your help
Is there a document on how to build Extender Views? I tried to build one but got lost very quickly.
I will answer my own question and actually read the manual.
If you would like to submit an answer or comment, please sign in to the eOne portal.