Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

I would like help with automations and triggers, when a record matches a condition (not specific)

Topic Labels: Automations
117 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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

Link fields

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