Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoOne way to do this is to not use any Proxy fields on your relationships.
In Add/ Edit mode you will show the field [Related XYZ.
In view mode you only show the lookup fields.
Then have 8 form rules,,
when [related XYZ] is greater than 0
Show name XYZ
Show phone XYZ
then a similar form rule for the other 7 relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
In Add/ Edit mode you will show the field [Related XYZ.
In view mode you only show the lookup fields.
Then have 8 form rules,,
when [related XYZ] is greater than 0
Show name XYZ
Show phone XYZ
then a similar form rule for the other 7 relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
AndrewFry
6 years agoQrew Assistant Captain
​Ok, I think I follow you.
As a follow-up question, if I change the relationships to not use proxy fields, am I still able to do conditional filtering?
The layout is as follows:
The lists in the type dropdowns are conditional upon the client selected.
This shows me only the Job Contacts (for example) for client ABC when that client is selected, and does not show me the Job Contacts for client XYZ.
Would I still be able to do a conditional filter if I don't use proxy fields?
------------------------------
Andrew
------------------------------
As a follow-up question, if I change the relationships to not use proxy fields, am I still able to do conditional filtering?
The layout is as follows:
The lists in the type dropdowns are conditional upon the client selected.
This shows me only the Job Contacts (for example) for client ABC when that client is selected, and does not show me the Job Contacts for client XYZ.
Would I still be able to do a conditional filter if I don't use proxy fields?
------------------------------
Andrew
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
yes
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- AndrewFry6 years agoQrew Assistant CaptainOk, thanks for the clarification.
Looks like I have some work cut out for me to re-do the relationships ...​
------------------------------
Andrew
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Whoa, you definitely do not need to redo any relationships! Just show the [Related XYZ] in edit / add modes and the lookup field sin view mode and then you can use the form rules.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------