Changing record picker value based another record picker

Question

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------------------------------

xavierfan · Answer

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/
------------------------------

adamkeever1 · Answer

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------------------------------

marchilliker · Answer

Thx Adam.

Unfortunately, I don't have anyway of knowing the field values for Field 1 ahead of time. It's a client list of potentially hundreds, if not more.

Marc

------------------------------
Marc Hilliker
------------------------------

marchilliker · Answer

Thx&nbsp;Xavier. I'll check it out. This looks like it might be exactly what I'm looking for.------------------------------Marc Hilliker------------------------------

Forum Discussion

Changing record picker value based another record picker

Related Content

Changing/setting record owner

Auto change record to 'Expired' when copied.

Nesting API Button Help (Add record and update another)

Moving Fields from One Table to Another

Custom Record Titles