topic Re: Survey123 Integromat Date in ArcGIS Survey123 Questions

Survey123 Integromat Date

Anonymous User — Mon, 24 Feb 2020 22:41:39 GMT

Greetings,

I am working on a integromat workflow that pushes Survey123 data into a google spreadsheet. I have a date field that is not always filled out. When it is filled out I need the date from Survey123 to format to a (MM-DD-YYYY), which I can succesfully do. If there is no date submitted through the survey I would like no data to populate the data field in the spreadshet, and for my scenario to continue. Currently I can format the date when it exists but I cannot get integromat to ignore the field if no data exists.(which breaks the scenario) If anyone has suggestions I would really appreciate it.

Re: Survey123 Integromat Date

Jim-Moore — Tue, 25 Feb 2020 06:33:55 GMT

Hi Michael

You could use an IF statement inside the Google Sheets module for the target date field, i.e. if the incoming date question is TRUE (contains a value) write the formatted date, else write null. The function might look something like:

Hope this helps.

Best,

Jim

Re: Survey123 Integromat Date

Anonymous User — Thu, 27 Feb 2020 21:56:26 GMT

Hi Jim Moore

thank you for the quick response, I have followed your suggestion but it does not seem to be working or me. I do not get any errors in my integromat scenario and all the other data fields are transferred correctly. I have attached a screen sot of my target field date.

Has it worked for ?

Thanks

Re: Survey123 Integromat Date

Jim-Moore — Fri, 28 Feb 2020 02:09:27 GMT

Hi Michael Van Hatten

Apologies, on further testing it looks like a condition of greater than zero should work (instead of =true). Please give something like this a try:

Best,

Jim

Re: Survey123 Integromat Date

Anonymous User — Tue, 03 Mar 2020 15:32:48 GMT

Jim Moore‌ this seems to have done the trick!

Thank you very much