Has anybody used the Import CSV Pack by @Bharat_Batra and know if I can add data to a new column during the import process? My workflow is I have a button using the Importcsvtocodatable function and it is working great. That button is in a table with the data needed for the function. I also have another row with a Date that is entered by the user. I would like that date to be entered as a value in the column in the table that is being imported into (each new row being imported would use this same date). This date column does not live in the csv file being imported from.
Not sure if I there is a way to do it within the function of the packs formulas or if I need to figure out some Runactions formula.
Thanks!
Hey Ben! Unfortunately there’s not a good way to add columns programmatically at the moment.
Your best bet is to create the column manually and then run the import either through the pack or through coda’s native CSV import functionality.
Thanks for the reply Bharat. I think I might use a temp table to import into, then add my new column data and then have all that data copied into the primary table.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.