Latest Contributions by MarkBennett

Hi John,  As I suspected, the attachment table related via OID is cause! Once I change the PK/FK to GlobalID and re-published service with sync enabled, the supportsApplyEditsWithGlobalIds became true!  Because this is a legacy database that was developed and accumulated over 10 years, many of the relationshipclass were created using oid for PK/FK. It will be nice to have tool to converte to GlobalID:).  Ming ... View more

Hi John, The fgbd contains many data sets and attachments, therefor, it is very big in size (1.4 GB and 700MB compressed). I am going to strip it down and then ask you for ftp link. Both feature classes in FGDB contains attachments and I noticed that the ATTCH tables and featurclass is related using OID instead of GlobalID in FGDB. I am not for if this could be a problem to set the “supportsApplyEditsWithGlobalIds” to true?! Ming Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 ... View more

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