Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
8 years ago

Use a drop down menu instead of pop-out record picker

Currently, I am setting up alternate relationships between tables for filtered drop down tables. I join the two tables on record ID, then use a proxy field that is a text look up and use a report I ge...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Look for the field typically called Related Parent. (Whatever your Parent is called). Then edit the field properties for that fiel then there is an option to force the Record Picker.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
A solution is this is to set up a Conditional Drop down and have the user first select a letter of the alphabet or a range of letters like A-K and L-Z.

Then he dropdown for the choices will be less than 1,000.

So you would have a multiple choice filter, say 26 choices form a to Z.

The make a calculated field on the main data field to calculate that same value, ie the first letter.

Then make the drop down be conditional on having first selected the letter of the alphabet.