Pulldata with dates

253
1
Jump to solution
08-05-2021 02:14 PM
KerryKang
Occasional Contributor II

Hello all, 

I have a scenario where users select a week number (string) and also need to select from/ to date using date fields. To reduce manual entry for dates and prevent typing errors, I used pulldata as shown below so from date and to date fields are auto-filled when users select a week number. It works fine in the mobile app, but it does not work in the web form - is it expected behavior due to 'date'? I thought it would work because it's still pulldata functions.

Does anyone know if there is a workaround?

 

Thanks.

 

Kerry

KerryKang_0-1628197392872.png

 

0 Kudos
1 Solution

Accepted Solutions
Philip-Wilson
Esri Frequent Contributor

Hi @KerryKang,

It looks like the problem may be related to using a comma in the data. As the pulldata is using a CSV, which is a comma seperated value, the commas in the data may cause an issue, if not quoted. Can you try remove the commas or quoting the data values in the CSV.

If that doesn't work, can you share the XLSForm - xlsx file and csv files used in media folder so we can take a closer look.

Regards,

Phil.

View solution in original post

0 Kudos
1 Reply
Philip-Wilson
Esri Frequent Contributor

Hi @KerryKang,

It looks like the problem may be related to using a comma in the data. As the pulldata is using a CSV, which is a comma seperated value, the commas in the data may cause an issue, if not quoted. Can you try remove the commas or quoting the data values in the CSV.

If that doesn't work, can you share the XLSForm - xlsx file and csv files used in media folder so we can take a closer look.

Regards,

Phil.

View solution in original post

0 Kudos