Looking to hire a consultant that provide an audit and clean up of our data and workflow in Airtable. Seems that several workflows are starting to break.
Question
Looking to Hire Consultant
Hi! I’m interested, if you’re still looking for support.
+32Hi
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, and the idea is for us to work on some stuff together during the call so that you can see if we're a good fit!
If you think I could help, here's a link to schedule a free half hour call, and the idea is for us to work on some stuff together during the call so that you can see if we're a good fit!
Best of luck either way!
+35I’m not currently taking on new clients because I’m at maximum capacity right now, but if you’re still looking for help later in the year (Sep/Oct timeframe), feel free to reach out:
Hi KHolmesPJP - I can help with this kind of Airtable cleanup.
I would start by separating broken automations/views from the underlying data-shape issues, then give you a short fix order and handle the first cleanup items if the access/scope is straightforward.
If you are still looking, happy to take a look at the base/workflow outline here.
+7
Five replies in and nobody has asked what "starting to break" actually looks like, so here is the diagnostic I would run before paying anyone, including me.
Workflows breaking in a base that used to work is rarely one bug. It is usually one of four things, and you can check all of them yourself in about twenty minutes.
1. Automations failing quietly. Open each automation and read its run history, filtered to failed runs. A failed automation does not make the rest of the base look unhealthy, so it is common to find one that stopped weeks ago and nobody noticed.
2. A "when record enters view" trigger pointed at a shared view. The automation does not own that view's filter. Anyone who edits the view to make their own work easier changes what the automation fires on, without ever opening the automation. If your triggers use views, check when those views were last modified and by whom.
3. A field that was retyped or recreated rather than renamed. Renaming is safe and Airtable follows it everywhere. Changing a field's type, or deleting it and making a new one with the same name, is not: formulas and automation steps that referenced the old field tend to go blank rather than fail loudly, which is why this one hides.
4. Two automations touching the same record. Airtable has no row locking, so an automation running on create and another running on update can overlap on one record. That produces the worst kind of bug: intermittent, fine in testing, and only visible under real load. If your symptoms are occasional rather than constant, look here first.
The reason to run that before scoping a cleanup is that the answer changes what the job is. If it is the first one, the fix is an afternoon. If it is the fourth, no amount of tidying the data will help and the logic itself needs restructuring. Those are very different quotes, and you should not accept either until someone can tell you which one you have.
Happy to look at it with you if useful. But do the twenty minutes first, because whoever you hire should be arguing with your findings rather than starting from a blank page.
...that and OP says they’re specifically looking to hire a consultant.
Also, not sure what it says about being a member of the community if any kind of response to a post immediately opens by rebuking every other response that came before it.
+10workflows are starting to break.
Can you share me one workflow that recently broke, I can help you trace it step-by-step?
Your AirTable workflows/automations fail or behave unexpectedly, that could be related to certain issues.
- Automations failed runs, changed trigger conditions, or permissions errors
- API/integration credentials expired/revoked tokens
- Renamed fields, changed field types, deleted fields, or changed linked-record structures.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.