Hi,
i suppose, you define input variables in a correct way (otherwise script would not reach output step).
it should be something like that
Well, i had some school programming backround very long time ago, before Windows era, and refused to understood all those object-oriented stuff from books. But it’s easier to learn when you create something yourself. you are not supposed to be a developer, but to work in airtables, you need to get some basic things.
I think it fails because some of your fields type is not ‘string’.
if you put text field value in some variable, like ‘temp’, you work with it directly.
some fields, like single select, multiselect, lookups, contain
arrays, it’s like a box of ordered values [ ‘Monaco’, ‘Paris’, ‘Nice’ ]
or objects, the box of named values
in my example, “rec” is object. it may be described as
{current:‘Monaco’, last:‘Paris’, temp:‘Nice’}
You can refer to Field types reference for more info.
But right now, let’s see what you got here:
try to paste this, to see your data types, and i’ll tell you how to fix it
let rec={...input.config()}
output.set('last',typeof(rec.last))
output.set('current',typeof(rec.current))
output.set('temp',typeof(rec.temp))
Hi Alexey and thanks one more time for your time and patience.
Regrind work with airtbles - I know that I really should learn coding basics to use all features and to be able to build really powerful thinks - but to be honest I don’t know from what to start - it should be html or JavaScript?
About your kind last script suggestion - here what is the output from it:
Hi,
It seems like you didn’t define input parameters
here is a sample how it should be done.
After you defined them, you can begin write a script.
Parameters stored in read-only variable input.config()
If parameters are defined, you will see it as possible values, when typing variable name, like this
The rest are as described before
I don’t think you’ll need html for it. Regarding JS, for now it’s enough to read and understand some basic examples, like this
i supposed you already prepared first automation step, like this
if not, i would recommend to try and create some simple automation, without scripting at all, just get some value by trigger, put in to other cell. then, after you automation executed succesfully, you will better understand how to create the same, but using script after trigger, like on my last picture.
