Skip to main content

These tables are all on 1 database by the way.




I have been playing around with automations and a trigger that matches conditions, but it gets specific. For instance, I am trying to: when I type in a case number which is xxxx-xxxx, it will prefill another field where it will put the abbreviation from the Center ID table for me. Example on there is 01209-0085. I want to match the condition whenever I type in 01209, it will automatically prefill in CC SJD (from Center ID). I’m sorry for bad explanation.

Hi Dalena, if I were you, I would use a linked field instead


I’m assuming all the case numbers in the Main View will be unique


If so, I would make the primary field of the Main View the case numbers. In the Grid View, I would create a formula field that would help us distinguish the unique case number, and then I would use an automation to paste the unique case number into a linked field


Once the records are linked, we can then use lookups to view the abbreiviation



I’ve set it up here for you to check out

Reply


Terms & Conditions