The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have a transaction table that is collecting post information through a serverless function. When I get those transactions, I want to run an automation that will look for am email address and, if found, update the contact record, if not found, inser...
I have a table called Things and another called Options
The Options table has a list of attribute columns and each has an associated Cost Modifier
NameType (Color, Size, Shape, Special)Cost Modifier
The Things table has Lookup values that point to vi...
Please pardon my passion! I do understand (now) that I was “preaching to the choir”! When I was responding to the previous comment, I had assumed it came from an Airtable mediator.
Yes, you could copy a script between bases (which I currently do), bu...
In every API there is a need for an Upsert action. Without it, you have to write a custom script every single time. You have all the parts there and the difference between insert or update is really just a conditional statement.
I have put in several...
Ok Sportsfans, (I think I may be the only one), I solved this conundrum!
How to combine and use multiple Lookup fields in a rollup:
Use an Automation.
Create an Lookup field to the Options table (AutoOptions)Create an Rollup field (AutoOptions rollu...
@Jason
Thank you for the suggestion: does a Sample base illustrate the question better? I linked one above.
The two long way work around options are in the Thing table.
The first is to Lookup the costs for each category and then sum them. Works fine ...
Here is a link to Sample Base
What I am trying to solve is this:
I want to aggregate the linked records into once field, the use the Linked records to create a Rollup on the Cost for those unique records.
Anyone have a suggestion on this?