Airtable algorithms

Hello,

Is anyone using Airtable in combination with algorithms?

We have a monthly toy subscription business and use airtable to keep track of our inventory and customer history.

Currently, we are manually assigning toys to customers based on:

  • Our stock
  • Age of the child
  • Price of the toys
  • Previous toys given to this customer

I was wondering if it would be possible to write an algorithm that would do this automatically based on the rules we write? And how would that integrate with airtable?

Thanks!

You’re probably looking at using a 3rd party like Zapier or Azure Logic Apps (among others) to do this sort of thing. At a very basic level, it would work like this:

  1. Poll Airtable for records that need to have the algorithm applied them
  2. Apply your business logic in Zapier or Logic Apps
  3. Set the field(s) based on the result of your program

Zapier is pretty easy to get started with but I prefer Logic Apps because it’s what I’m familiar with.