Skip to main content
Question

How do i move data from one field to another automatically?

  • February 27, 2019
  • 0 replies
  • 45 views

I am making my company's forms to be more relationship based rather than everything being a simple text field.  I built a relationship between two tables called Support Tickets and Contacts.  On support Tickets, there was text field called "Apt#".  I created a new field called "APT#" which is now a text lookup field.  So when the field "full name" (a text lookup field and relationship to full name on Contacts table) on the table "Support Tickets" selects a customer's name, it will automatically fill in the field APT# in the table "SUpport Ticket".   How do i have the information from the old text field Apt# move the information into the new field APT# on the table "Support ticket"?  Could i have modified the old field "Apt#" to be a text lookup?  If so, wouldn't all the original data in that field be lost?  Thank you.
This topic has been closed for replies.

Use automations: https://www.quickbase.com/blog/quick-base-automations,
If you don't want to lose data after changing data that is linked to a lookup, you should use a Snapshot.:
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html