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 ...
