Hello everyone, I have a scenario where I am extracting entries from Google Sheets (different types) and pass it to #Airtable using #Make (#Integromat)
The error that I'm getting is "Invalid URL in parameter", I mapped the fields from G Sheets (URL) to the fields related I have in Airtable (Type: URL). The URL fields that have value didn't throw any errors, only the empty fields have thrown this error.
Below you can find the scenario in #Make (#Integromat)
below is the module (Upsert a record in #Airtable) that have the errors):
As you can see from the previous image, When I tried to map the field as is while it's empty it threw the error, and I tried to use (ifempty) formula but the same happened.
Does anyone have any idea of how to handle empty fields (especially URLs) ?
let myDynamicValue = "My changing value"; let myVariable = myDynamicValue ||"A Default String";
This returns "My changing value"
If we set a null-ish value, the default string kicks in;
let myDynamicValue = null; let myVariable = myDynamicValue ||"A Default String";
"A Default String" returns when myDynamicValue is null/undefined.
This is a common coding practice within an Airtable Script extension/automation - is there anywhere within your tech stack to write such code?
Thanks Karlstens for your answer, I'm trying to keep it simple "no code" in this project. The only tools I'm using right now is "Make" and "Airtable", and at the end i planning to add "Softr" to it.
The weird thing is that other fields that I have empty is not returning any errors (other types: Text, Single Select, etc.). Links is what making these errors.