nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Integromat Date

Anonymous User

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.

Trouver plus de publications taguées avec

Accepted answers

Jim-Moore

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

All comments

Anonymous User

Jim Moore‌ this seems to have done the trick!

Thank you very much

Jim-Moore

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

Anonymous User

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

Jim-Moore

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

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.