Latest Contributions by js80540

‎05-05-2022

Have any of you experienced this? No matter which records I tried to view or edit from the sent or inbox, the survey appears empty? I have not set a where clause so I am not sure where could this coming from Any ideas?

‎04-26-2022

Oh wow! Thank you! I really wish this was mentioned in the documentation, a few other people seem to have the same issue on the forum since the documentation suggest using date(). Thanks again!

‎04-25-2022

I actually just changed it for the sake of clarity before posting here, this is not the source of the issues unfortunately. Here are two updated files renamed. Thank you!

‎04-25-2022

Hello, I have seen this question pop-up a few times but never really any official answer. I am pulling a date ("2021-04-01") from a csv file, which I would like to ingest in a form as a date object (using date()) in order to add 21 days to it and check against current date. I am stuck at the first step though, I can't seem to be able to convert the string of a date to a date object. So with my date being pulled from the csv and equal to '2022-04-01', stored as test_dob. date(string(${test_dob})) returns mismatch error, but if I do date(string('2022-04-01)) it works no problem. So it makes me wonder how this date actually get stored in the back-end. And why it displays perfectly but doesn't get ingested as expected in the date function. I have attached a csv sample and the table from which i am trying to pull (names are fake by the way). I am using the last S123 Connect Thank you very much for your help.

‎04-25-2022

Did you ever find an answer? I am having the same issue

‎04-25-2022

Has anyone found a better way yet? I believe i am having the same issues, this seems counter productive. Thanks for the trick though! It sure helps in the meantime!

‎04-08-2022

I found two work arounds, and implemented one. But please let me know if there is something easier! One solution is using concat in the repeat to create a json like structure to store all the data. Then using join outside of the repeat to make a list of json like object contain, each item containing the data for one repeat. Which in turn can be parsed using a custom javascript function... Messy and dirty but it works. The second solution I have found, which only works because I have only three values to store is using join. Using an if in my calculation within the repeat, I insure that only one value will be returned for all the repeats iteration. The join outside of the repeat will then only have one value to join and will have stored the data I need. Here is an image showing the mess : Not pretty but it works, I am sure there are better way to do this so let me know 😄

‎04-08-2022

Hello, I am trying to save a set of specific values from a repeat in order to do some validation. To simplify here is what I want to do : Repeat 1 : Question 1 = ph Question 2 = 7 Question 3 = 20 Repeat 2 : Question 1 = orp Question 2 = 124 Question 3 = 5 Repeat 3 : Question 1 = ph Question 2 = 4 Question 3 = 15 Outside of the repeat I want to store the Q3 value in one variable (call it store_ph_7) if Q1 = ph and Q2 = 7 and in another variable (call it store_ph_4) store the Q3 value for Q1 = ph and Q2 = 4 Then I have a note popping up if X - Y > 1 Is there a way to do this? Repeats will never be in the same order and the actual form have way more options so I can't rely on counts or indexes. I based my structure on the assumption that I could store any value from the repeat using a set of relevant rules but apparently it doesn't work that way. I tried using once() but that didn't work either. Anyone has a clever trick to do this?

‎04-23-2020

Hello, I have been looking at a few tutorials and most of them mention the possibility of adding formats, links and such in the side panel of a Shortlist story maps using HTML. I would like to include some links, bold text, lists, tables etc in the description but the HTML never gets translated into actual formatting. Example this is provided in one of the document I found : But it is displayed as HTML in my story. Am I missing something? Note that I am using the ShortlistBuilder Thank you so much for your help

Online Status	Offline
Date Last Visited	‎05-05-2022 05:52 PM

My Ideas

Latest Contributions by js80540

Surveys look empty when viewing from inbox or sent box

Re: Pull date from csv and use in calculate (type mismatch)

Re: Pull date from csv and use in calculate (type mismatch)

Pull date from csv and use in calculate (type mismatch)

Re: Type mismatch converting text to date

Re: type mismatch - converting to date

Re: Extract values from repeat for calculation

Extract values from repeat for calculation

Shortlist - Side panel HTML support

Re: type mismatch - converting to date