Forum Discussion

bradyakers's avatar
bradyakers
Qrew Cadet
28 days ago

Way to do Editable Lookup Fields?

I was wondering if there is a way to do an "editable lookup field"?  I have 52 tables - one strictly for contact information for all US states, and one for each state that has some of that contact information, as well as some added columns for tracking our data on them. These tables do need to be separate with the way our workflow and filters need to be set up. 

 

I would like to be able to set it up to where if we are working on the tracking table and we find a better email, if we update it on that document, it updates on the master contacts.  And vice versa, contacts updates our state's tracking sheet.

 

I believe lookup fields are non-editable by nature, so I didn't know if you all would recommend something? I have lightly tested out a pipeline method for this, but I would need many pipelines to accomplish this effectively.

  • I think I'm more practical solution is to provide the user with a button to update contact email. That would simply be a hyperlink to the contact record where they can do the edit. As soon as they do that the improved email address will instantly flow down to the Child table that they were originally on.