Skip to main content

auto-fill data

  • May 29, 2024
  • 2 replies
  • 33 views
E
Forum|alt.badge.img+4
  • edge
  • Participating Frequently

How can i auto-fill a linked field?

i have 2 linked tables in Airtable: CONTENT and CONTENT TYPES

In the table CONTENT i have two linked fields CONTENT TYPE and WORKFLOW 

In CONTENT TYPES i have the two "originals" of CONTENT TYPE and WORKFLOW

If i select in the CONTENT table the linked value CONTENT TYPE and this CONTENT TYPE has a DEFAULT WORKFLOW (i.e. cell is not empty) then the WORKFLOW field in CONTENT table should auto-populate with the DEFAULT WORKFLOW value.

Basically only if there is a default workflow (cell not empty) of the Workflow column in the content type table, then this value should be auto-filled on a linked field in the CONTENT table. 

Hope this makes sense? I know this can be done with an automation inside airtable. but how?

2 replies

Sistema_Aotearo
Forum|alt.badge.img+20

Could you provide screenshots to help me understand what you're looking for?

You might be able to do this with automations and/or a "look up" or "roll up" field.

From my understanding, you simply want to link a WORKFLOW to the CONTENT depending on what CONTENT TYPE is selected?

 

Justin NgProgramme Coordinator at Sistema Aotearoahttps://www.sistemaaotearoa.org.nz/
E
Forum|alt.badge.img+4
  • edge
  • Author
  • Participating Frequently
  • May 30, 2024

Hi, Thanks for looking at this. I am totally stuck here.
I created an airtable that shows what i want to achieve 

https://airtable.com/invite/l?inviteId=invBQZLlFEVSONEXd&inviteToken=e4487b2eb45a328e2e997098f1a864d581e116c9a89364c5754478aa6e8aed69&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts


This is the cell: https://airtable.com/appILm5TSS1LZWooa/tblzs5MRhD1TbJZmv/viwEgv7nn9D2A0vdA/rec81LcTiLxqCm1Ri/fld3oCmMSYVCWJxto?copyLinkToCellOrRecordOrigin=gridView

Action needed: If there is a Default Workflow set for a specific Content Type that cell should be-autofilled with the default value. I can not use the Lookup field because I need the option to override the default workflow if needed.

 

Terms & ConditionsAccessibility statement