Get date from csv

ChrisRoberts2 — Fri, 02 Sep 2022 01:08:41 GMT

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

Re: Get date from csv

ZacharySutherby — Wed, 07 Sep 2022 01:56:41 GMT

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

topic Get date from csv in ArcGIS Survey123 Questions

Get date from csv

Re: Get date from csv