I’m combining the data from a number of tables in a new table. I’m grouping my view by project each project has some costs I wish to display. I also have staff members that work for a particular project they have costs I also wish to display(yellow)...
I’m calling an Apps Script which works as intended in the browser. However when using automation I get the error. I have read that this is to do with google redirecting the url.
I don’t need to receive anything back from the script as everything is...
I just can’t find the right way to format my request. I’m trying to update a single field in a single record. but keep hitting - INVALID_REQUEST_MISSING_FIELDS",“message”:"Could not find field “fields” in the request body
Getting data is fine.
Afte...
In the image you can see it pulling in the whole record (2020 Sweden), But I actually only want to display a single field from that record.
Is it possible to do this?
Hi Leonardo, So two things were causing me problems. one on calling the script in airtable. I needed to remove the redirect follow from the line bellow it seems apps script doesn't like that. let response = await fetch(urlRequest, {method : “Get”, ...
They are indeed. But if I remove those lookup fields I would loses the total above which I would like to keep. (currently set so avg so they display the correct amount)
Hi @Rose_K ,
Thanks for replying!
I have the summary of Total operational costs and the Total costs which is great, including all the fields that add up to that. It’s more about what I want to hide which is everything in the red area, this is repeate...
Hi Bill, Yes there were two issues,
I solved the permissions issue on the script last(after setting up integromat).
So I just went back to my code posted above. Ran it again with the apps script URL…fail TypeError: Requests that follow redirects are ...
Just an update for anyone else with the issue. That will hopefully save some headaches.
Following redirects is not currently possible. See Airtable redirects
As per advice from Airtable I used integromat as an intermediary service.
The process is pre...
