​@Sam Way 

You could write a lengthy formula (or perhaps a custom JavaScript) to process all 6 of those different inputs. Hopefully, someone will chime in below with the formula and/or JavaScript that you could use.

However in my personal opinion, the easier & quicker way to convert phone numbers into your desired format would be to use Make’s free phone number conversion module, in conjunction with Make’s Airtable modules.

Make’s phone number module will take any input (even beyond the 6 that you’ve listed above), and convert the input to your preferred country (Australia) & formatting (xxxx xxx xxx).

Below is a screenshot of one of the ways that you could setup your scenario (i.e. automation) in Make.

The scenario below starts with a webhook, which you can instantly trigger from Airtable by following my instructions here for instantly triggering a Make webhook from Airtable. I’ve also assembled a bunch of Make training resources in this thread.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

​@Sam Way 

You could write a lengthy formula (or perhaps a custom JavaScript) that would convert those 6 different inputs into your desired phone number format. Hopefully, somebody will chime in below with a formula or JavaScrip that you can use.

However, in my person opinion, the easier & quicker way of doing this would be to use Make’s free phone number converter module.

Make will take any input format (even beyond the 6 input formats that you listed above), and will convert it into a phone number that is formatted for your preferred country (Australia) and preferred formatting (xxxx xxx xxx).

My screenshot below shows one of the ways that you could setup this automation in Make. This automation starts with a webhook, and you can instantly trigger a Make webhook from Airtable by following my instructions here.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

 ​@Sam Way 

You could write a lengthy formula (or perhaps a custom JavaScript) that would convert those 6 different inputs into your desired phone number format. Hopefully, somebody will chime in below with a formula or JavaScrip that you can use.

However, in my person opinion, the easier & quicker way of doing this would be to use Make’s free phone number converter module.

Make will take any input format (even beyond the 6 input formats that you listed above), and will convert it into a phone number that is formatted for your preferred country (Australia) and preferred formatting (xxxx xxx xxx).

My screenshot below shows one of the ways that you could setup this automation in Make. This automation starts with a webhook, and you can instantly trigger a Make webhook from Airtable by following my instructions here.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

While you could write a lengthy formula (or a JavaScript) for this, I think the better way to do this is to use Make’s native phone number conversion tool for this.

I tried typing an entire message here with screenshots and instructions, but it wouldn’t let me post my response. No idea why. It just kept giving me an error. If you DM me, I can send you a screenshot with instructions.

- ScottWorld, Expert Airtable Consultant 

Hi,
Your numbers could be formatted by this formula