Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoWhat is in [File]. Is that perhaps the name of the file? if so you can test is that is blank.
But a better way would be to create the field at the source and have an IF to make it blank if the file is missing. Then look up that link down to children and it will truly be blank if here is no file. Then a form rule can hook on blank.
Since you have to build that link anyway as you may as well always build the link on the Source table and then look up the link as opposed to constructing the link at the Target. The other advantage is that perhaps for some reason where you create the link at the source might be a parent to some other child tables so you might get lucky and be able to use the same source field in two different relationship look up fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But a better way would be to create the field at the source and have an IF to make it blank if the file is missing. Then look up that link down to children and it will truly be blank if here is no file. Then a form rule can hook on blank.
Since you have to build that link anyway as you may as well always build the link on the Source table and then look up the link as opposed to constructing the link at the Target. The other advantage is that perhaps for some reason where you create the link at the source might be a parent to some other child tables so you might get lucky and be able to use the same source field in two different relationship look up fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------