Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
5 years ago

Capturing A Field Value To Set Up Boolean For Custom Data Rule

I have records on a parent table with a field [Job].  The value in this field is passed down to the child records.  I currently have form rules in place that prevent users from changing the value in [...
Custom Data Rules
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
How about a low tech solution.  Make a formula field called [Job.] (with a period).

Make the formula just a mirror equal to the [Job] fields.   Put that on the embedded report.  In Grid Edit, formula fields are not editable.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JonFroderberg's avatar
JonFroderberg
Qrew Cadet
5 years ago
I like this approach! Thanks Mark!

My colleague pointed out that I was attempting to do a summary (average) on a text field (which is the incorrect data type) which in turn was causing the QB error message, not that it was a circular reference.  I could go to the effort of creating an additional field which would translate the Job on the parent record into a numerical value and then set up all the related fields to evaluate an average from the children, but that's a lot of machinery to create when Mark's idea is much simpler.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------