Conditional Dropdown on Connected Table

Question

I know there are multiple workarounds for this - but just wanted to know if there is a way to do any sort of conditional dropdowns between two QuickBase Connected Tables.

I have a table report in App 1 that I wish to bring over some fields into App 2 that meet the exact filtering requirements of the report in App 1. However, the filtering requirements have many conditional subsets that I need to account for.

Thanks,

Niraj

------------------------------
Niraj Shah
------------------------------

markshnier__you · Answer

If you just want to import a subset of the records from one table into another and the filtering is complex, you can make a formula checkbox field to flag records which qualify to be Sync'd across.

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

evanmartinez · Answer

Hi Niraj,I would agree with Mark that one of the more accessible ways to do this is to build out a formula that mimics the filters you want to use for your records. That way when you go to filter your Sync table you are pointing to a single field that has all the logic you already need (Which can also make it easier if that filtering criteria needs to change later since you can go right back to that field). You would just say if Include In Sync formula field is equal to checked then sync over records.------------------------------Evan MartinezCommunity Marketing ManagerQuick Base------------------------------

nirajshah4 · Answer

Thanks, Evan - that's exactly what I ended up doing.------------------------------Niraj Shah------------------------------

Forum Discussion

Conditional Dropdown on Connected Table

Related Content

Embedded Grid Edit Report Pre-filtered Conditional Dropdown

Conditional Dropdown to MultiSelect

Conditional formula url

Connected App same realm

Check one field for multiple conditions