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
mark.shnier@gmail.com
------------------------------
CeciliaMullan's avatar
CeciliaMullan
Qrew Trainee
6 years ago
OMG that is wonderful. Thank you so much!!!

------------------------------
Cecilia Mullan
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    ya, 
    Save and Next would have got "old" in a hurry.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • CeciliaMullan's avatar
      CeciliaMullan
      Qrew Trainee
      6 years ago
      Totally - this is a lifesaver. I had no idea I could copy and paste columns like that. Thank you again!

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