Forum Discussion

CeciliaMullan's avatar
CeciliaMullan
Qrew Trainee
6 years ago

Dynamic Form Rule to Create New Unique Record Key - Opening/Saving ALL records?

Hi there,  I want to circumvent the rule that you cannot have a formula field as a Record Key for my Contacts table by creating a formula field that concatenates Account + Contact in the Contacts For...
Grid edit
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
np
Make a report with two columns.
Filter where Key field is not equal key field formula

Go into grid edit.
Click the blank column heading for Key field formula and right click to Copy
click the key field blank header and right click to Paste

Repeat until none left

Then actually change the key field from Record ID# to the Key field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
CeciliaMullan's avatar
CeciliaMullan
Qrew Trainee
6 years ago
OMG that is wonderful. Thank you so much!!!

------------------------------
Cecilia Mullan
------------------------------