Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoIs there a valid field in the Advanced Properties for the table for the first Record Picker field?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MichaelTamoush4 years agoQrew CaptainYes, but not a great field so I changed it. Still no luck. Perhaps this is a mission for customer support?
------------------------------
Mike Tamoush
------------------------------- MichaelTamoush4 years agoQrew CaptainUpdate:
Working with Customer Support and we have not pinpointed the issue, but leaning towards it is a bug. One interesting thing: If I create a formula field that is a mirror of the proxy field, and add that as a column in the report, suddenly the behavior is exactly as expected.
No idea why yet....I tried mirroring other fields, putting dummy text, etc, nothing worked. But for some reason, actually having a mirrored field seems to help??
Also, I think it works with the related field, but not if using a proxy field.
------------------------------
Mike Tamoush
------------------------------- MichaelTamoush4 years agoQrew Captain
In the event someone stumbles on this post, according to customer support this is expected behavior in a cross app relationship.
If needed, use the work around I provided by creating a mirrored field to the proxy field.For mine, I took it one step further. The proxy field simply needs to be included on the mirror field, other items can be there. So I made a rich text field, mirrored the proxy field but made it size 1 font, and white (so essentially hidden), then mirrored another useful field. Works out pretty nice. No clue why it works but, there it is.
------------------------------
Mike Tamoush
------------------------------