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.
Hello all!I use airtable e.g. for recording and analyzing event data. In event data i have "start" date and time, and "end" date and time.When I set the filter "the past number of days" (e.g. 30 days) to the event data, it would appear that the curre...
Hey,
I am a sports coach and I use Airtable extensively for planning coaching activities and recording athlete results.
I have created an Airtable environment where I can plan training themes on a weekly level and use the weekly plan to support the p...
Hey,
I need to create a formula something like this:
If field_1 = “text_A”, then;
If field_2> field_3, “Text_B”, “Text_C”
Otherwise “Text_D”
I don´t know how to do it and I couldn´t find from community or google…
Anybody?
Thanks
//Mikko
Thanks...Moment ago I solved the problem by replacing word "recordId" with "RecordID" at the script. Weird, but it worked...Anyhow, Thanks for the solution Adam. As I said, it´s just what I needed.
Hey, This is just what I need right now. Thank You! Anyway, I get an Error from testing the script. It says: "ERRORError: Field "(Field ID)" cannot accept the provided value.at main on line 12"I can´t figure this out. @TheTimeSavingCo Do you have an...
Hey,
We ended up using a script as part of the automation. The script adds up the money and number of the rows that meet the criteria, creates a new row “Predictions” in the table and records the result in the created row. Naturally the script writes...
Thanks Adam!
The third table is exactly my idea. I just haven’t been able to build a workflow that would gather the tasks of the same month into one summary record and add up the amount of money predicted for that month.
In that record, I would like ...