Take my *Airtable Crash Course* and learn the basics here: 👉garethpronovost.com/airtable-crash-course 👈 Grab my *FREE TRAINING* that teaches the building blocks of automation: 👉www.garethpronovost.com/webinar-registration👈
Again Gareth, this is a skill you have of explaining processes in such a fluid and simple way! Am amazed every time (and also jealous ;) Will you ever give trainings on how to develop this skill you have? Loll Luc
Hi Gareth. Very informative as usual. I really don't know how you keep doing this, but thanks! Just thought of another way (excl automation) to replace the data, based on what was shown. Change the field type of the formula that was created to type Email (if the replacement has to do with email domains), and then delete the original Email field. Same for Text etc. Not great if the field to be deleted is referred to elsewhere in the base though.
Great info! I wish Airtable would allow me to update a single field based on a form. My use case: I use a form to create a new record with a travel start time. Once I finish my trip I would like to use a form to find the previous record I made earlier in the day and enter the end time. This would be a game changer.
You can build an automation to do this for you! It will take a new form submission and update a preexisting record. We've done a video on this before, although I don't have the link on hand.
The fastest way would be to write a custom script that looks for all 100 words in one go. However, I suspect the time to write the script would be similar to the time it would take to go through each of the 100 words manually...
@@GarethPronovost Yeah, I thought it may be something like that. I have ended up just continually doing Find and Replace and using multiple select to remove. Appreciate the help.
Take my *Airtable Crash Course* and learn the basics here: 👉garethpronovost.com/airtable-crash-course 👈
Grab my *FREE TRAINING* that teaches the building blocks of automation: 👉www.garethpronovost.com/webinar-registration👈
Fabulous thank you! i used find/replace formula and it i did it in seconds! 😊
Thanks for watching!
Again Gareth, this is a skill you have of explaining processes in such a fluid and simple way! Am amazed every time (and also jealous ;) Will you ever give trainings on how to develop this skill you have? Loll Luc
Lol, thanks Luc! I wish I knew how to teach it!
Hi Gareth. Very informative as usual. I really don't know how you keep doing this, but thanks! Just thought of another way (excl automation) to replace the data, based on what was shown. Change the field type of the formula that was created to type Email (if the replacement has to do with email domains), and then delete the original Email field. Same for Text etc. Not great if the field to be deleted is referred to elsewhere in the base though.
Thanks Shaun, great idea!
Great info! I wish Airtable would allow me to update a single field based on a form. My use case: I use a form to create a new record with a travel start time. Once I finish my trip I would like to use a form to find the previous record I made earlier in the day and enter the end time.
This would be a game changer.
You can build an automation to do this for you! It will take a new form submission and update a preexisting record. We've done a video on this before, although I don't have the link on hand.
Any idea how to do this quickly with a list of 100 words to find and replace?
The fastest way would be to write a custom script that looks for all 100 words in one go. However, I suspect the time to write the script would be similar to the time it would take to go through each of the 100 words manually...
@@GarethPronovost Yeah, I thought it may be something like that. I have ended up just continually doing Find and Replace and using multiple select to remove. Appreciate the help.