Get date from csv

ChrisRoberts2

Hi All

I have recently change my forms to generate the list from csv's hosted in my Portal using select_one_from_file.

This is really useful as I can keep lists updated/maintained without having to get the user to download the form again each time a list is updated.

My question is currently I have a note stating 'Taxonomic lookup lists current as of May 2022' which I previously manually updated each time I updated the list.  Would it be possible to grab the updated date from the csv so that the date is automatically calculated?

Cheers, Chris

ZacharySutherby

Hello @ChrisRoberts2, 

You can add two new columns to the CSV something along the lines of "last_update" & "value" for example and include the date in the last_update column. Since it's a CSV and will be present in the Media folder you should be able to use a regular pulldata() function to pull the "last_update" value from the CSV. 

Ex. 

CSV:

name	label	last_update	value
a	A	Sept 2022	1
b	B
c	C

 

Then in the XLSFrom use pulldata('csv_file', 'last_update', 'value', '1')