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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 05-21-2020 17:30
From: Cecilia Mullan
Subject: 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 Form and then a dynamic form rule that transfers that combination into a text field. I want to to use this text field as my new Record Key for my Contacts. I just imported over 4,000 contacts and the only way that the dynamic form rule triggers is when I open and save a Contact. Is there ANY way to force this rule to fire without having to open and close 4,000 records individually? I already explored an automation and an action and neither seem to offer a solution. I can't believe I will have to spend hours clicking on each record just to get this to work. PLEASE HELP.
------------------------------
Cecilia Mullan
------------------------------