POST
|
I'm not sure I know what you mean by "Well if all the other options have not been picked then you know all your calcs are 0." All of the calculations are turning up 0 when they absolutely should not be.
... View more
04-23-2019
09:11 AM
|
0
|
4
|
700
|
POST
|
Hi Doug, I think I am getting really close now. I am having trouble with the last statement though. I think it is obvious by now that I have never been and am not now a programmer. Your suggestions really helped. Technically, the sign names are as long and horrible as you say. It is not the label. I could and probably should separate them and make them easier to work with, but I am scared to undo my work and potentially mess something up. I'm not sure what to do for my last statement. All the sign areas are still 0, even when the sign is specified to use a different equation. I want all signs to use my final equation if they were not previously mentioned in the other sign area equations. This is my last statement: if(${signtype}='R1-1 - Stop' or ${signtype}='T3B - Type 3 Barricade' or ${signtype}='W10-1 - Grade Crossing Advance Warning' or ${signtype}='W14-3 - No Passing Zone (Pennant)' or ${signtype}='S1-1 - School' or ${signtype}='SS4-5 - School Speed 15 MPH Ahead (Symbol)' or ${signtype}='M1-7 - NFS ROUTE MARKER' or ${signtype}='M1-6 - County Route Sign (1 - 3 digits)' or ${signtype}='R1-2 - Yield 36x36' or ${signtype}='R1-2 - Yield (Low Volume Roads)',0,(${widthnote} * ${heightnote}) div 144) I basically just reversed the statement and included all the signs that use other equations, but I think that just defaults ALL the signs to use the last equation. I'm thinking I'm not going about it the right way. Thanks for all your meticulous help.
... View more
04-23-2019
06:54 AM
|
0
|
9
|
700
|
POST
|
It looks like I am having trouble with the "or" statements in my calculations and the "Max" line for the final calculation. Any idea why? Also, it tells me I am missing a ")" when I get rid of "selected." Ideas?
... View more
04-22-2019
01:18 PM
|
0
|
11
|
700
|
POST
|
I'm not sure I know what you mean. Do you mean I should expand my survey by adding more notes with subsequent signArea labels? Like this? note signArea Sign Area: if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${widthnote} div 12), 2) div 2.4), 0) note signArea Sign Area: if(selected(${signtype},'M1-7 - NFS ROUTE MARKER' or 'M1-6 - County Route Sign (1 - 3 digits)'),pow((${heightnote} div 12), 2) * 0.76, 0) note signArea Sign Area: if(selected(${signtype},'R1-2 - Yield 36x36' or 'R1-2 - Yield (Low Volume Roads)'),${heightnote} * ${heightnote} div 333, 0) note signArea Sign Area: if(selected(${signtype},'S1-1 - School' or 'SS4-5 - School Speed 15 MPH Ahead (Symbol)'),${widthnote} * ${widthnote} * 0.0052083, 0) note signArea Sign Area: if(selected(${signtype},'T3B - Type 3 Barricade'),${widthnote} div 12, 0) note signArea Sign Area: if(selected(${signtype},'W10-1 - Grade Crossing Advance Warning'),(${widthnote} * ${heightnote}) div 182.5, 0) note signArea Sign Area: if(selected(${signtype},'W14-3 - No Passing Zone (Pennant)'),${heightnote} * ${heightnote} * 0.0042918, 0) note signArea Sign Area: Max((${widthnote} * ${heightnote}) div 144) Is that anything close to what you are suggesting? Thanks for all your help.
... View more
04-22-2019
12:20 PM
|
0
|
13
|
1063
|
POST
|
Thanks Doug! That worked! How many of questions am I able to add into a nested if statement? These are all the 8 formulas I have: (Width * Height)/144 (The majority of the signs have this equation) (SQUARE(Height/12)) * .76 ((1 + (SQRT(2))) * 2) * (SQUARE((Width / 12)/2.4)) (Height * Height /333) (Width * Width * .0052083) (Width)/12 (Width * Height)/182.5 (Height * Height * .0042918) What if I have multiple sign types for each equation (can I go by category in the same equation)? Should I put the equation with the most signs at the end of the equation?
... View more
04-22-2019
09:48 AM
|
0
|
15
|
1063
|
POST
|
Here is what I get without that last 😞 Here is the error with the extra 😞
... View more
04-22-2019
09:17 AM
|
0
|
17
|
1063
|
POST
|
Would a nested if statement with two of your equations look something like this? if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4)), (${width} * ${height}) div 144 This equation is not working for me. I have never done any calculation this intense and have a lot of questions.
... View more
04-22-2019
08:21 AM
|
0
|
19
|
1063
|
POST
|
On top of that, when I try to do a calculation with even one of my formulas, the area does not change if I alter the width and height in the survey. I'm not sure Survey123 is that dynamic.
... View more
04-18-2019
11:07 AM
|
0
|
0
|
776
|
POST
|
Hi Jim, I have ended up restructuring my survey so many times. I am using the pulldata function to pull what I can for width and height so I can calculate area. It's working well, but now I have run into needing a nested if statement will all my formulas. The syntax is killing me when I try to put them all together.
... View more
04-18-2019
11:02 AM
|
0
|
1
|
776
|
POST
|
I would like to have a series of questions asked only if one of option of the previous question is chosen. This is the example: If the survey taker chooses to salvage a sign, they don't have to fill out the following questions about the sign. If the survey taker chooses to replace, leave existing, or install a sign, the following questions about the sign appear to fill out. Is this possible?
... View more
04-18-2019
10:12 AM
|
0
|
3
|
709
|
POST
|
You're awesome, Doug! That works like a charm and you saved me so much time!
... View more
04-17-2019
11:08 AM
|
0
|
0
|
1461
|
POST
|
Thanks Doug. That's a good option too. My problem is that my calculated if statement does not have a quantity if the feature is not found. Here's an example of what I want to be able to do: Some signs require an input of the sign width and height during the time of inspection (this differs from stop signs that are always the same size no matter the location). If I need to complete a survey for a sign saying you are crossing into a new county, that sign will differ in size depending on how long the new county name is. I would like to have sign width, height, and area automatically calculated for predetermined (pulldata) sign, like a stop sign, and be able to input the width and height for custom signs before an automatic area calculation (most signs have a different area calculation). If I used an if statement, I'm not sure how I would even phrase it (I'm new to the XLS version of Survey123). Here's the sign width example: Am I on the right track with that if statement? Can I or should I even use if statements? Thanks! Kaitlyn
... View more
04-17-2019
07:55 AM
|
0
|
2
|
1461
|
POST
|
Hi Brandon, Thanks for helping me out; I've been in quite the rut. My problem is that there is a current system available that is about 4 times shorter and I would like to beat it in efficiency, performance, and speed. The pulldata function works well for me; however, I need a way to edit the pulldata on the survey form in case it is not correct (there are many signs that don't fit the exact pulldata information or require different solutions). Is there a way to edit the pulldata? If not, what do you suggest I use?
... View more
04-17-2019
05:41 AM
|
0
|
4
|
1461
|
POST
|
I am struggling with which columns to use for a series of questions in my survey. What I need from my survey is the ability to answer multiple questions directly from the previous questions in my survey. For example, the signing project I am doing requires a question for 'sign type,' 'sign quantity,' 'post quantity,' 'post dimensions,' and 'post height,' and all these questions are intertwined depending on the 'sign type' answered at the beginning of the survey. A couple specific examples are as follows: 1. If sign type is equal to 'stop sign (36x36)' the post quantity should automatically default to '2 posts' and the post dimensions should be 'square tube.' 2. If sign type is equal to 'any kind of object marker (All OM sign types)' the post dimensions should be 'u-channel' and the post height should be '7 feet.' -side note: One type of object marker need a default of '0 posts' to give context on how complex this survey is going to have to be. My struggle is with which columns I should be using to decipher this information, what calculations, and whether or not this survey is too complex to make efficient. There are over 200 sign types I am working with, so I originally thought using the pulldata function was the best way to sort out the categories of signs. I have used relevant statements to add questions if necessary. I also began trying if statements, but those seemed challenging due to the amount of sign types there are. What am I doing right or wrong? How should I be sorting my data? Does anyone have any recommendations? I have attached my data to make this question easier to answer.
... View more
04-15-2019
07:41 AM
|
0
|
6
|
1834
|
POST
|
I have several groups right now that will not allow me to add members unless they have a creator user type. I want to add viewers and field workers to these groups. The field workers must be a part of the group to input content using Survey123, but the members are always rejected when I try to add them as field workers. I only have two role options, viewer and data editor, so I'm not sure if that is something contributing to this problem. Originally, I tried to switch them from creator to field worker user types, but I got an error message saying that the member user roles could not be changed due to belonging to a group with "update capabilities." I would like to rather not have to open this group to the entire organization if possible, but I have tried it both ways and they have both failed. This is the error message I get when I try to add them as field workers: My settings are as follows: What am I doing wrong?
... View more
04-09-2019
07:16 AM
|
2
|
1
|
3258
|
Title | Kudos | Posted |
---|---|---|
1 | 07-20-2020 01:13 PM | |
1 | 09-29-2020 02:54 PM | |
1 | 12-24-2020 10:23 AM | |
1 | 03-24-2020 05:11 AM | |
1 | 02-05-2020 08:42 AM |
Online Status |
Offline
|
Date Last Visited |
08-14-2023
09:43 AM
|