Input.fileAsync force change ID to Date.
//read csv
let latestStock = await input.fileAsync('Please CSV',
{
allowedFileTypes: ['.csv'],
}
);
console.log(latestStock);
↑It’s true ID"0002-3". But Date format.
If Do you know resolve. ...
I wanna delete cells-value in Amount Field.
I am referring to this↓
Airtable
Airtable | Everyone's app platform
Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, a...
Hello. Nice to mee you.
I have this probrem.Preformatted text
please let me know.
//get table info
let table = base.getTable("A2_複製");
let queryResult = await table.selectRecordsAsync();
let record;
let stocks = new Array(2);
//I wanna set to array...
Thank you so much :star_struck:
I got original ID in your way.
but My ID has additional " in each value.
How can I remove additional " ?
I think conect replace. but I couldn’t by my skill :sweat_drops:
This is csv text date.
And I have another ...
Thank you so much. This is a screen shot.↓
The Yellow cell are is turning into Date.
kuovonne:
Are you saying that 0002-3 is turning into Mar 2 2001 (the second day of the third month)?
Are you seeing the same behavior in all of the rows of da...
Thank you so much. I’m sorry for the late reply.
Dominik_Bosnjak:
With that said, I’m not 100% clear on what you’re asking. That value at index 0 is a date but shouldn’t be? Or is it just the format that’s the problem?
The value at index 0 is ...