Search the Community
Showing results for tags 'look up table'.
I have a field taken from a Dropdown. The source is a lookup table. From drop down I set "name" to Field for display and "email" to Field for value. Later on I need to use the string in the Field for display, e.g. use the "name" in the email. Is it possible?
I am new to Caspio and getting familiar with cascading dropdown menus powered by a lookup table. I have configured the menu by selecting the "parent field", "filter by", "field for display", and "field for value" options but one of my lookup table fields is not showing under "field for value" options - in particular for the last dropdown menu item. As a result, I am forced to pick a duplicate "field for value" for that menu option, which is not what I want. Has anyone encountered that problem and if so, do you have advice on how to get last lookup table field to show as a "field for value" option? All of my lookup table fields are data type Text (255) except the field that won't show under "field for value", which is a data type Text (64000). Not sure if that has anything to do with it.