Latest Contributions by MarkBennett

Sorry John, I used my client's account to ask the question above. Please reply this one if you have a answer!  Ming ... View more

I think that this has something to do with the platform. I found that the value returned from the URL is different between for the desktop and the for Android system. Ming Get Outlook for Android<https://aka.ms/ghei36> ... View more

I found a solution to this issue if you do not want set the code/label the same: 1. suppose we have code/label pairs 1/A; 2/B; 3/C 2. add a hidden question in your survey and set the fieldType to "null"; 3. In the url, pass the source data to this hidden question. It will pass the label, "A", "B", or "C" to the hidden question; 4. Put a "if(condition, true, false)" statement in the Calculation Column for the target question. The formula should looks like this:          if(${Hidden}='A','1',if(${Hidden}='B','2',if(${Hidden}='C','3',null)))  it will pre-select "A", "B", or "C" if a valid valve is passed to the hidden question, otherwise, it will select nothing. This works for me! Ming ... View more

Hi Joe, I may not explained clearly. The survey is based a flushing table related to hydrant feature layer.  Every time when a survey is submitted, a new records is added to the table and I users can see it.  However, the feature layer is NOT edited. Therefore, I'd like to have a way to update the LastFlushed field after a survey is submitted. Thanks, Ming ... View more

Oops, I logged in with another user name. Please replay to this one instead the post above. Ming ... View more

The second question is resolved: The error is caused by a space between "if" and "(". Instead of if (....., it should be if(..... . The first question remains? Thanks, Ming ... View more

An interesting observation: when I use the web map to set it up and try, it seems web map generated correct value for both code domain and GlobalID! See picture! Ming ... View more

Deal all, Running into another issue to pass data from Explorer to a "select_one" question in survey. As stated, "The value to insert after the equal (=) sign is the actual value that will be stored in the feature service. If you are working with select_one type of  questions this is very relevant, since the value you must pass is that of the XLSForm Name of the choice, rather than its Label." However, the value Explorer passed to survey is the "label", not the "code/name", if a "code-label" Domain is used for that field.       For example, I have a Manufacturer field with Domain in Feature Layer and 'select_one' question in survey. In both "domain" and "choices", I have an item using 'AMRF' as code/name and 'American Flow Control' as label. For prefill the form, Explorer should pass the 'AMRF' to Survey. However, it passes the 'American Flow Control' to Survey.                To work around tis, I tried to pass the data to a hidden null field and use a conditional formula "if (${Manufacturer1}='American Flow Control', 'AMRF', null)". However, it returns an error for the expression: SyntaxError: Expected token ';' in expression: if ... ...       Well is seems that I have two questions:           Am I correct about pass a code-label domain data to a 'select_one' question for pre-fill?           Is my approach to work around it correct? If so, what did I do wrong? Thanks, Ming ... View more

That helps a lot! The trick is the set the Field TypeNull! I tried to use the hidden field without set it to field TypeNull. Thank, Ming Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 ... View more

Hi James, I am trying to created a survey using existing related table. When user click on the survey URL in the pop-up, the GlobalID of the feature would passed to the GUID field of the related record. The Url works fine and the GlobalID is passed to the desired field. However, it seems that the GUID field would only take the string value of the lobalID without the "{" and "}". Is there anyway to pass the GlobalID to survey without "{}". Or, Submit the GlobalID to the service without "{}"? Thanks, Ming ... View more

Hi James, I downloaded the 3.0 Alpha. However, I cannot find the documentation on the use of this function. Could you help me locate the usage of this function? Thanks, Ming ... View more

Is there any update on this function in the new release? Thanks! ... View more

James, Thanks for the prompt responses to my questions!  All these tree questions are related to the behavior for add attachments to a survey. If there is a "wish list" for the functionalities of Survey123, may I add the followings: 1. The behavior of handling the attachments (for images, audio, video, text files or any other files) is preferred to be the same as handling attachments for a feature service (Have a related Attachment table and using GlobalID as the keys). 2. A "begin/end attachments" type may be used to handle the multiple attachments with same type. 3. For the annotation, it will be great if user can select (not pre-defined) an image as the background of drawings. If user can open a Web Map and draw on the map, it is also very useful. Thanks and looking forward to seeing even greater Survey123! Ming ... View more

Hi James, I have created a number of surveys using existing feature services. these surveys are integrated with WF and Collectors. Regarding photo, annotation, drawing, or attachments in general, I have following questions: 1. Can I select a file (not image file, any file such as 8.txt) as attachment? 2. For the type of image and appearance as Draw, can field user has the option to select and open an image as the backdrop instead taking photos? Ex. open a screen-capture or a existing photo. 3. Can user add multiple photos, drawing, or attachments? It seems one can use the "repeat" to add more than one images or voices.  However, it may force user to set up an"one-to-many" related table to handle repeated data items at one survey location. In case of attachments, Feature-service or FGDB seems already using a related attachment table to handle multiple attachments with the blob data type. So, can multiple attachments handled in Survey without created addition related table? Survey123 is really a great product and thanks a lot for the excellent work! Ming ... View more

Thanks for let me know! Ming Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 ... View more