Skip to main content
Solved

Control text from a list

  • November 10, 2023
  • 4 replies
  • 28 views
C
Forum|alt.badge.img+3

I have the followign problem.

In a cell I have a list of tags, separated by a comma, i.e.

Apple, Banana, Grape

Then I have a control list of allowed tags, that is

Apple, Banana, Strawberry

So, the formula should eliminate the tags Grape is it is a now allowed tags, and return this resul

Apple, Banana

Any ideas on how to obtain it?

Thank you very much in advance

Regards

 

 

Best answer by Dimitris_Goudis

In short yes 🙂

thank you very much in advance! 


Thanks @Cristiano_Volpi, 

Formulas are not able to do that by covering all potential scenarios of values in text fields. To achieve your goal based on my experience I would recommend one of the following options:

- Use Zapier or make.com creating an automation that will analyze text and it will return the values you need

- Use an automation with a script that will do this process inside the Airtable. 

Does it make sense? For any kind of question please do not hesitate to post.

Yours sincerely,
Dimitris Goudis 

4 replies

Dimitris_Goudis
Forum|alt.badge.img+20

Hey @Cristiano_Volpi, 

Is your actual problem the need for a formula that will recognize the common tags in those 2 fields and it will return only the commons? 

Thanks

Yours sincerely,
Dimitris Goudis

C
Forum|alt.badge.img+3
  • Cristiano_Volpi
  • Author
  • Participating Frequently
  • November 16, 2023

Hey @Cristiano_Volpi, 

Is your actual problem the need for a formula that will recognize the common tags in those 2 fields and it will return only the commons? 

Thanks

Yours sincerely,
Dimitris Goudis


In short yes 🙂

thank you very much in advance! 

Dimitris_Goudis
Forum|alt.badge.img+20

In short yes 🙂

thank you very much in advance! 


Thanks @Cristiano_Volpi, 

Formulas are not able to do that by covering all potential scenarios of values in text fields. To achieve your goal based on my experience I would recommend one of the following options:

- Use Zapier or make.com creating an automation that will analyze text and it will return the values you need

- Use an automation with a script that will do this process inside the Airtable. 

Does it make sense? For any kind of question please do not hesitate to post.

Yours sincerely,
Dimitris Goudis 

C
Forum|alt.badge.img+3
  • Cristiano_Volpi
  • Author
  • Participating Frequently
  • November 28, 2023

Dear Dimitris,

thank you very much for suggestion, at the end I have decided to use Zapier with ChatGPT 100% no code 🙂
So far seems that AI can handle the task very well.

Dimitris_Goudis
Terms & ConditionsAccessibility statement