Would like to have an extender field show a list of names to the user but save numeric IDs in the database
Rod asked 7 years ago
I would like to have an extender field show a list of names to the user but save numeric IDs in the database, for a specific field. Otherwise, what if the administrator changes the name of one of the values. All other values will lose reference. Is that possible?
Thanks
Thanks
Answers
Patrick Roth Staff answered 7 years ago
Rod,
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.
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.
Rod replied 7 years ago 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?
Patrick Roth Staff answered 7 years ago
You can create Extender Views with that window in Extender.
And depending how you are moving the data – maybe. If just in SQL then yes you’d have to be careful.
And depending how you are moving the data – maybe. If just in SQL then yes you’d have to be careful.
Rod replied 7 years ago Thanks for your help
Rod replied 7 years ago Is there a document on how to build Extender Views? I tried to build one but got lost very quickly.
Rod replied 7 years ago I will answer my own question and actually read the manual.
Thanks