Select to view content in your preferred language

Get date from csv

312
1
09-01-2022 06:08 PM
ChrisRoberts2
Frequent Contributor

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

0 Kudos
1 Reply
ZacharySutherby
Esri Regular Contributor

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:

namelabellast_updatevalue
aASept 20221
bB  
cC  

 

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

Thank you,
Zach
0 Kudos