You are an excellent teacher, thank you for sharing this video!

@GarethPronovost

3 жыл бұрын

So glad it helped!

Beautiful! 🔥🔥🔥

Thank you! This video helped me to complete my task

@GarethPronovost

2 жыл бұрын

Glad to hear it! 🙌

Muito Obrigado! Me ajudou dmais! muito bom! (Thanks!Helped me a lot! very good!) (Brasil)

@GarethPronovost

3 жыл бұрын

Thanks for watching!

Hi Gareth Thanks for video will keep as reference for when I need it. What I need right now is to extract the amount and the frequency (Month/Week) from this field '£950.00 per Cal Month' into 2 different fields. Do you have any video which could help please?

is there a way to identify a hard return in a long string of text in airtable? (We sync with jira and put all our details in a field in jira but then need to pull out pieces and parts when that field once synced in airtable). I want to find the copy that comes after a particular string. Like: Month: January. (find "Month: " and return the copy after it stopping at a hard return. Your videos are awesome. I'm gonna play with the strategy you provided in this video to see if i can get it.. Thanks!!

Great video thank you! My search string is "OrderID: #" followed by a 12 digit number. How can I omit the search string and just keep the 12 digit number from the result in the formula?

Awesome video - thanks. Now I have a curveball for you - what happens if the string appears more than once? For instance, let's say I have @XYZ and @ABC in a string. I can now find and pull the first one but what about the second one? 🙂

@GarethPronovost

Жыл бұрын

If you're looking for two specific strings within a longer string, can you write two formulas? One for each string?

Thanks Gareth ! This is really useful ! Exactly what I was looking for, however, I found a problem with my table... What happens if there are multiple photos attached, and I only want the first image URL and ignore the rest?

@GarethPronovost

3 жыл бұрын

This definitely throws a monkey wrench in the formula! In this case, you might create another table specifically for attachments and link that table to your first table. This way, each record in your Attachments table only holds one attachment and the formula still works, but you can link multiple attachments to each record on your first table.

@juanantonioscott

3 жыл бұрын

@@GarethPronovost Thank you !

Thank you, great vidéo as usual!!! I need to find an end number to extract a texte with different between two "/". Is it possible?. Thanks

@GarethPronovost

2 жыл бұрын

Yes, that sounds feasible. You might just try the VALUE() function if this is the only number in the string. If not, you can build a more complicated formula using the tips I outlined in this video! 💪

Hi Gareth, I’m finding your videos of great use as an new Airtable user. Can you tell me how, in this video, the last fields’ formula removes the unwanted final parentheses. You say the ‘Len’ formula gets the length of the string. Does this mean it finds the URL, exclusive of extra parentheses, or all of the characters in the ‘Image URL’ field? I’m a little confused. Thank you.

@GarethPronovost

3 жыл бұрын

Hi Martyn! LEN calculates the number of characters in the string (outputs a number) including the parenthesis!

@MartynWhite

3 жыл бұрын

@@GarethPronovost So, to be clear, Airtable ignores the last parenthesis It’s so fussy with syntax I’m surprised.

Hello there, thank you for your video. I have a problem regarding a formula generated content -> i would like to convert the generated content into a dropdown in another field. Is it possible ?

@GarethPronovost

6 ай бұрын

You can't use a formula to generate a dropdown, but you can use an automation!

Can you please suggest to me a formula that will remove a text after multiple characters ( ‘’,‘’ ‘’/‘’ ‘’ - ‘’ ‘‘and’’ ‘’&‘’ ‘’;‘’ ‘’(‘’. I already found on this Forum the formula that removes a text after one single character, LEFT( {Column name}, FIND( “-”, {Column name} )-1 ) Can you please advise me on how to add to this formula options for other characters, or maybe the new formula that will have a such workflow, thanks in advance

@GarethPronovost

Жыл бұрын

Hi Marta, sounds like you want to try the SUBSTITUTE formula. You can search for characters individually and replace them with null values.