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
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')