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.
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
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 !!!
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.