Airtable Consultants?

[maggieduross]

Hello,

I think I'm at my limits with trying to get Airtable to function as we really envisioned.  Anyone know the best place to find Airtable consultants with likely programming abilities?  

A few of the things we really wanted to do were:

1. Create a custom form that goes to contacts and their selections would filter back into our main table but this needs to be very limited with selections as certain items we code on contacts are internal only.

2.  A mass emailer.  We use Airtable as a giant database for our independent contractors and code them by areas they cover and preferences.  We have Zapier and an external operations system and would love the ability to integrate all so that we can send a mass email to a designated list of names/email addresses based on a filter that looks nice and inputs the key job data available from our operations software (SQL Server database).  Have struggled with this one and even though we have the Stripo HTML email created it can't be used in Airtable with our messing around with it.

3. General functionality improving a bit for all the other various needs.  Even things like notifications is messed up as it will send a notification for every letter typed in a field instead of when it is done.

Thanks! 

Maggie

[ScottWorld]

If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[TheTimeSavingCo]

Hi @maggieduross , I'd be happy to help with this!  Not sure which programming language you're looking for in particular, but I'm familiar with JavaScript if that helps? 

I'm pretty active on the forums so you can get a grasp of how I work from my activity here as well as some reviews, and I've got a bunch of example projects that you can find here!

If you think I could help, here's a link to schedule a free half hour call to see if we're a good fit!

===
re: 3. General functionality improving a bit for all the other various needs. Even things like notifications is messed up as it will send a notification for every letter typed in a field instead of when it is done.

Hm, this one's interesting.  Is this an Airtable automation where the trigger's set to "When record is updated" and is pointed at a text field?  If so, you may want to consider using a checkbox field instead to trigger the automation, and the workflow would be:
1. User keys in all their data into the text field
2. User ticks the checkbox
3. Automation gets triggered and sends out the notification, and also clears the checkbox

You can also handle this automatically by using a formula field to calculate how long it's been since the field was modified and then triggering the automation 5 minutes after that, but that might make your base laggy if you've got a lot of records though

[Sachin_191]

Hey @maggieduross 

Sounds like you’ve got an ambitious Airtable setup in mind, and I’d love to help streamline everything to bring those features to life For your custom contact form, I suggest designing an Airtable form or, if more customization is needed, integrating a third-party form solution (like Jotform or Typeform) that writes selections directly into your main Airtable base while keeping internal-only fields private. This way, your contacts only see what’s relevant to them, while you retain full control over backend data.

For mass emailing, I recommend using Airtable's filtered views combined with Zapier to pull targeted contact lists. Then, we could explore linking your SQL Server data through APIs, allowing us to trigger email campaigns in tools like SendGrid or Mailchimp. This setup would provide a branded, HTML-compatible email format using your Stripo designs, while making the process seamless from Airtable to email.

[Dimitris_Goudis]

Hi @maggieduross ,

Regarding email: have you looked into connecting Zapier? I and my clients get a lot of control with not a lot of work that way. Airtable automations don't generate custom styling.

You've mentioned a few key challenges, particularly with creating custom forms and integrating email functionalities. 

I'd love to discuss your project further and explore how I can assist you in achieving your goals with Airtable. Would you be open to a no-obligation call to dive deeper into your requirements? You can easily book a time on my calendar link below or DM me: https://calendar.app.google/dLdsoircej81euaN8

I am a certified Airtable expert with over 5 years of experience in optimizing workflows and creating custom solutions for clients. One of my past projects involved developing a sophisticated mass email system integrated with client databases, similar to what you're aiming for. 

Best,
@Dimitris_Goudis