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
------------------------------
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
------------------------------
