The processing (or calculations) I need to perform are currently done in a Google Sheet. The calculations in the sheet are straightforward but have about 20 steps, and the final result is a string (an array) in a cell in the Google Sheet. I want that result in a cell back in AirTable.
In summary, here’s what I’m currently doing that I need to automate without Google Sheets:
Any apps or integrations that I can perform what I’m doing currently in Google Sheets in an automated fashion that doesn’t involve writing a bunch of code? After all, I could create the output desired in a Sheet… seems there ought to be some other tool to swap in for Google Sheets.
Thanks for any thoughts/ideas!
Solved! Go to Solution.
all no-code solutions including calculation of summary value of several records done by linking all them to single record in other table and doing something with that, using rollup, and/or formulas.
Here you can find a lot of info that may help you:
Are there any no-code, low-code solutions outside of AirTable?
Thanks Alexey for your contribution. I see a potential way to do it in AirTable with computation tables with lots of rollups and formulas, but it seems a very messy.
Without fully seeing what you’re trying to do, you might be able to accomplish this with our no-code On2Air Action app.
It has over 60+ functions that work directly with Airtable, including a Airtable > Google Sheets sync, Math calculations, and a VLOOKUP option if needed (among other options)
Here’s a list of all the functions and features
If this interests you, you can try it out on the trial. Feel free to reach out in the chat about what you’re trying to do.