Skip to main content
Solved

Creating Records from Multi Select or Linked Fields

  • November 10, 2022
  • 4 replies
  • 138 views
J
Forum|alt.badge.img+4

Morning everyone,

I have a couple of questions about this solution posted by @Adam_TheTimeSavingCo (Thanks Adam, it works really well!): Create records from multiple select field choices

Question 1: Is there a way to populate a field in the new table using data from the multi select? Using the example base linked in the topic above, I would like the 2nd table to look like this after running:

Question 2: Is there a similar function for linked records? I have done the below manually, but the initial table would like this, and then would have the same output on table two:

Thanks,
Jordan

Best answer by TheTimeSavingCo

Hi @Jordan_M! I’m glad I was able to help

I think the simplest way to handle that would be to add a formula field like so:

SUBSTITUTE(
  Name,
  {Table 1} & " - ",
  ""
)

Which would result in:

And here’s the base

Same applies for the linked field version I reckon

If you absolutely need a select field, then Mohamad_Swellam’s suggestion re: a script or external service would be the way to go

4 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Jordan_M ,

For question 1:
The short answer is yes, but you need to create a script for that.

Another way would be to use Zapier (specifically Looping by Zapier) to achieve that.

For question 2:
This would be the same as the multi select.

J
TheTimeSavingCo
Forum|alt.badge.img+31

Hi @Jordan_M! I’m glad I was able to help

I think the simplest way to handle that would be to add a formula field like so:

SUBSTITUTE(
  Name,
  {Table 1} & " - ",
  ""
)

Which would result in:

And here’s the base

Same applies for the linked field version I reckon

If you absolutely need a select field, then Mohamad_Swellam’s suggestion re: a script or external service would be the way to go

Adam, Airtable Consultant - thetimesaving.company
J
J
Forum|alt.badge.img+4
  • Jordan_M
  • Author
  • Participating Frequently
  • November 10, 2022

Hi @Jordan_M! I’m glad I was able to help

I think the simplest way to handle that would be to add a formula field like so:

SUBSTITUTE(
  Name,
  {Table 1} & " - ",
  ""
)

Which would result in:

And here’s the base

Same applies for the linked field version I reckon

If you absolutely need a select field, then Mohamad_Swellam’s suggestion re: a script or external service would be the way to go


Y’all are awesome, this is perfect!

Just for anyone else that happens to read this in the future, I utilized the “calculation” field to populate the drop down. It may not be the most elegant way, but it does what I want and doesn’t involve script or Zapier!

The basic idea is a separate automation: when a record is created in table two, it updates the “option” single select field to what is in the “calculation” field.

Here is the base with the automation, hopefully I share this correctly: Updated base

Thank you to both @Adam_TheTimeSavingCo and @Mohamed_Swellam !!!

TheTimeSavingCo
airballer86
airballer86
Forum|alt.badge.img+18
  • airballer86
  • Known Participant
  • March 12, 2023

Y’all are awesome, this is perfect!

Just for anyone else that happens to read this in the future, I utilized the “calculation” field to populate the drop down. It may not be the most elegant way, but it does what I want and doesn’t involve script or Zapier!

The basic idea is a separate automation: when a record is created in table two, it updates the “option” single select field to what is in the “calculation” field.

Here is the base with the automation, hopefully I share this correctly: Updated base

Thank you to both @Adam_TheTimeSavingCo and @Mohamed_Swellam !!!


@Jordan_M Thank you for sharing this base. I've been looking at ways to build the perfect QA checklist. I'm not sure exactly how your table will fix that issue, but I think it's close. Some way to Connect a checklist; select all the checklist items, and it autogenerates in to a new table. 

Terms & ConditionsAccessibility statement