Skip to main content
Question

Changing record picker value based another record picker

  • November 21, 2019
  • 0 replies
  • 38 views
How do I change the value of one record picker based on the selection made in a previous record picker within a single form?

------------------------------
Thx,
Marc
------------------------------
Thank you, [FirstName] [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
One method would be to use dynamic form rules and many multiple choice text fields.

Example Fields:
  • Multiple Choice Field1
    • Choice A
    • Choice B
  • Multiple Choice Field2
    • Choice C
    • Choice D
    • Choice E
  • Multiple Choice Field3
    • Choice F
    • Choice G
    • Choice H

Dynamic Form Rules Example:
  • If Field1 is A, show Field2
  • If Field1 is B, show Field3






------------------------------
Adam Keever
------------------------------
  • XavierFan
  • Registered
  • November 21, 2019
If you're talking about changing the value of the 2nd record picker - you can use form rules to change the value of the reference field, for example.

If you're talking about having the 2nd record picker only show certain values based on the selection of the 1st record picker, check out this online help article on "Conditional Dropdowns".   

Conditional Dropdowns
https://help.quickbase.com/user-assistance/conditional_dropdowns.html

------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------
    Terms & ConditionsAccessibility statement