Forum Discussion

LizChartrand's avatar
LizChartrand
Qrew Cadet
6 years ago

Way to create a multiple choice field that references records in another table

Hi,

I'm looking for any suggestions about how to create a multiple-choice field in one table (T1), whose options are records of another table(T2). The ultimate goal is to create a Kanban report that would be based on the multiple-choice (in T1) field that would also update the record in the other table (T2).

Thanks!

------------------------------
Liz Chartrand
------------------------------
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Can you explain this?

    The ultimate goal is to create a Kanban report that would be based on the multiple-choice (in T1) field that would also update the record in the other table (T2).

    I have a feeling that you are really asking that you want to use a Kanban report, but at present it only supports multiple choice fields. 

    if that is the case, then you would need to set up an Automation to update the field on your record for [Related Choice] to mirror the change in the multiple choice field which happens when the boxes are dragged around.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------