Forum Discussion

JoshCollins's avatar
JoshCollins
Qrew Assistant Captain
9 years ago

How To Select Multiple Choice Field Options from a Report

Is it possible to use a report to provide multiple choice field options?  Alternatively, is it possible to filter multiple choice field options so that the options appear only when they meet certain c...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
This is possible if you set up a Relationship where 1 vendor has many Projects.  They will be typically connected by the field [Related Vendor] and the lookup field and "Proxy" will be Vendor name.

Then on the FORM properties on the Project record for the vendor field, you can specify the report to be used for the drop down list of vendors, and it can be a report filtered to just show Electricians.
JoshCollins's avatar
JoshCollins
Qrew Assistant Captain
9 years ago
Thanks for the info.  I've got the 1st paragraph of your reply set up properly.  However, I can't seem to get the 2nd paragraph to work.

What field type should I be using? I am currently using a Text - Multiple Choice field and I do not have an option to specify the report to be used for the dropdown list when I am on the Form Elements page and looking at the field.  If I view the field properties, I can select a reference field for the dropdown list (ie- Vendors-Vendor Name), but I can't specify a report.