How do you populate a text field when a drop down list item from another field is selected?
Using shared value fieldsThere may be times when you want to display a list of choices for a particular field in several different tables or even across separate apps. For example, you may have a list of status choices ("started", "on hold" and "complete"), all of which apply to Projects and Tasks. Or maybe you'd like to take the list of cities that customers entered in one field and make it a drop down list of choices in another field. Show A shared value field allows you to take values from a text or numeric field and make them available as a drop down list in another field. You can even do so across apps, if you want. This feature not only eliminates the need to manually type in values for each record, but also makes it easier to maintain the list because you make updates in only one location, not in separate tables and applications. What a shared value field isUse a shared value field when you have several different tables or apps that need to access a list of known values unavailable elsewhere, such as Statuses, Project Phases, State Names, or Categories. A shared value field isnt recommended when you need a list of acceptable values entered into a Text - Multiple Choice field. You should use the From list input type instead. Remember, it is preferable to use a relationship to populate a drop down list. For example, dont use a shared value field to populate (for example) a list of customers drawn from the Customers table. Instead, create a relationship between the tables. When you do so, the relationship's reference field becomes the drop down list of choices. (Read more about relationships.) Create the source listTo create the source list:
Share the field containing the source list with other appsIf you are planning to make your source list available to other apps, you need to name each app that you want to access it. To allow a field to be the source for a shared value field:
Configure a field to display a list of shared valuesTo configure the field that should display values from the source list:
Did this page help? © 1999-2021 Quickbase, Inc. All rights reserved. Legal Notices. |