Forum Discussion

JemmaDicks's avatar
JemmaDicks
Qrew Trainee
3 years ago

Can I have more than three fields displayed in a default record picker?

I have an app which holds two tables with a relationship. One of the fields which is pulled through in my child table is a reference proxy from the parent table. 

So the user completes a form then picks the associated record from a drop-down and that data forms part of the record.

I can pick three fields to display for the user to select the right record. Three fields isn't really enough for them to identify the right record though. I can see under Advanced Table Settings there is an option to build custom data rule... not sure if this might be my solution...

------------------------------
Jemma
Data Analyst & Visualisation
United Kingdom
------------------------------
Forms
Relationships
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    np,
    You can make a report to use to drive the drop down list, so any columns, filters and dirt. Then set the FIRM properties fir that drop down field to use that report.

    Alternatively, you can make formula field(s) to concatenate serval fields together and change your record picker fields to use them instead of just single fields.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JemmaDicks's avatar
      JemmaDicks
      Qrew Trainee
      3 years ago
      Great, thanks for the info

      ------------------------------
      Jemma
      Data Analyst & Visualisation
      United Kingdom
      ------------------------------