Ruben_Rossvold - profile

Ruben_Rossvold · Apr 20, 2023

This will be a long post, and a intricate task because Airtable somehow in 2023 doesn't have a "date is current month" type of filters.I want to in my interface dashboard to summarize the total sales value within the current month. And in a statistic...

Ruben_Rossvold · Feb 08, 2023

The open url button field you can create always opens a new tab, and i don't want it to do that, is there any way i can modify the formula so it doesn't open a new tab? I can make a script field instead that stops this but i really don't want to spen...

Ruben_Rossvold · Dec 20, 2022

I get served a list of 500 company numbers every weekday at 5 am, i need to have available information for my sales agents by 7.30 am in the morning.This i solve by using an API that collects the information from a government website where i come fro...

Ruben_Rossvold · Dec 17, 2022

My record has a field that's named 'Automation history' which is where i want my scripts to keep a log whenever it does some changes, i keep this to identify errors etc. But the issue is that it get's replaced, is there any way to .push that value t...

Ruben_Rossvold · Dec 14, 2022

i will be as spesific as i can with the intention and infomation i'm gathering:At a scheduled time, every day at 8am, i will run a script.This script below here fetches the JSON i need. (example: https://data.brreg.no/enhetsregisteret/api/enheter?)Th...

Ruben_Rossvold · Feb 19, 2023

Yes i was able to solve it.In my case i was spesifically working on a website using SvelteKit, what i had to do is use a server sent type form instead.What stack are you using?

Ruben_Rossvold · Dec 23, 2022

So you want to create the next 7 working days as empty records or do they have to be filled with data VIA the script? If you just want to automatically always have the next 7 days you could to a scheduled automation run.On each monday at 1am,Create a...

Ruben_Rossvold · Dec 23, 2022

Declaring a count value outside of the for-loop and then making an IF 40 then break statement fixed my issue.let count = 0; // initialize count as 0 outside of the for of loop for (let record of records ) { if(count >= 50) break; // break out of lo...

Ruben_Rossvold · Dec 21, 2022

I read your answer again and i just realized what you meant with 25 actions.So if i make one automation with 10 scripting actions using the same script, it would actually fix my issue.I tested my script and it's able to go for 50 records in 21 second...

Ruben_Rossvold · Dec 21, 2022

Each company without the fresh info is stored in a filtered view showing the companies lacking the info, not needing the checkbox.Each fetch is really fast so that's not an issue.

User Statistics

User Activity

Filter sales this month.

Open url button opens a new tab

Airtable Automations

How to add to record instead of overwriting?

How do i make records based on fetched json?

Re: Open url button opens a new tab

Re: Create Multiple Records date using script

Re: Airtable Automations

Re: Airtable Automations

Re: Airtable Automations