POST
|
Hi Liudmila, I ended up figuring it out for my survey thus: ${#repeat_name}$${/repeat_name} Hopefully that helps you, too! -Jennifer
... View more
09-15-2020
10:11 AM
|
1
|
0
|
1258
|
POST
|
I have a survey built in Survey123 Connect 3.7.62 that was working just fine until I tried to update a field. I can delete the whole row with the problem field and re-publish without issue, and I was able to make a new survey copying the whole .xlsx file including the problem field in it and publish without issue, but I cannot get the existing survey to publish with that field. It gets stuck on "Adding Fields to surveyPoint: 1" under status "Information". When I look at the table data on AGO, the new fields have been added, but the publishing never completes in Connect. I can send the diagnostic log, in case that can help pinpoint what's failing, but prefer not to post it publicly - the error message during publishing is "[AppStudio@11205 category="default" filename="PublishSurvey.qml" line="533"] qrc:/qml/Connect/PublishSurvey.qml:533: TypeError: Value is undefined and could not be converted to an object". Any help is very much appreciated. Thank you!
... View more
02-18-2020
02:59 PM
|
0
|
5
|
1203
|
POST
|
Hi James, Yes, my repeat section is larger than one field. What I have currently in my survey is a set of non-repeat questions, and then repeats: select_one District eval_date begin repeat Survey_1 testrep autofill once(count(${testrep})+1) field_1 field_2 field_3 end repeat That section has a count of 40 to repeat across 40 assessment areas. What I'm trying to accomplish is a feature report template that can be auto-generated by Integromat once the 40th count is completed. I need the report to present the data in each individual assessment, so if the answers at assessment #1 are Spruce, healthy, 100%, and the answers at assessment #2 are Pine, diseased, 20%, I want to have a feature report that says Sample Assessment in District 5 Date: 1/24/2020 Sample 1: Spruce Status: Healthy Intact Bark: 100% Sample 2: Pine Status: diseased Intact Bark: 20% When I set my template up, it looks like this: Sample Assessment in ${District} Date: ${eval_date} Sample ${autofill}: ${#Survey_1}${field_1}${/Survey_1} Status: ${#Survey_1}${field_2}${/Survey_1} Intact Bark: ${#Survey_1}${field_3}${/Survey_1} Sample ${autofill}: ${#Survey_1}${field_1}${/Survey_1} Status: ${#Survey_1}${field_2}${/Survey_1} Intact Bark: ${#Survey_1}${field_3}${/Survey_1} But my output looks like this: Sample Assessment in District 5 Date: 1/24/2020 Sample 1 2: Spruce Pine Status: Healthy diseased Intact Bark: 100% 20% Sample 1 2: Spruce Pine Status: Healthy diseased Intact Bark: 100% 20% I'm having an easy enough time finding the data using the query function with ${field_1} where ${autofill}=2, so it seems possible, I just can't get the syntax right to pull it into a feature report for automation.
... View more
01-24-2020
02:20 PM
|
0
|
3
|
4659
|
POST
|
Sorry James, my question was overly ambiguous. Currently I have my feature report set up to pull from my repeats as ${#Survey_1}${field_name}${/Survey_1} but the output I get there is all 40 of the repeat answers for field_name. I'm trying to pull out the information for repeat 1, then repeat 2, then repeat 3, etc to create a report that reads consecutively across each repeat rather than an aggregate of all 40 repeats in each field. I implemented the once(count()+1) row that you suggested above, and I can see the row works perfectly in the exported xlsx but can't figure out how to use it to reference the fields from the rest of that row of data for the feature report. Can you provide an example of the syntax I would use to do this?
... View more
01-14-2020
01:05 PM
|
0
|
5
|
4659
|
POST
|
Hi James, Once I have the once(count()+1) set up, what is the syntax to reference a specific count in my report? Thank you! Jen
... View more
01-14-2020
06:26 AM
|
0
|
7
|
4659
|
Title | Kudos | Posted |
---|---|---|
1 | 09-15-2020 10:11 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|