POST
|
Thanks Jim, I knew there was a way to get there. On a side note, I'm actually trying to figure out how to style the prompt and the answer on the same line. So one line instead of four. This space saving is something I'm trying to incorporate into all my questions.
... View more
11-25-2019
12:40 PM
|
0
|
1
|
905
|
POST
|
Certainly, If you have data, let's say its something simple like the names of your field crew, that needs to be included in multiple forms and has the potential to change from time to time. Put the names into an excel file that will be your master for all data used in multiple forms. CREATE A BORDER - It would be a good idea to allow for additional employee names, so if you currently have 20 people in the field select 30 rows and allow for additional columns for their phone numbers, addresses, etc, in case you decide to use that, or any other, type of employee data in some way down the road, and put a heavy border around those cells. This is just to create a boundary that you know not to place any non-related data in that area of the spreadsheet. So now maybe you have 5 columns and 30 rows protected in your XLS, go to your choices tab in your XLSForm and link those cells in the master XLS to the XLSForm. This part is a bit of a pain to me, because its clunky and I'm sure there's a better way. If you know how to do the links, just ignore the rest of this, unless you can tell me how to do it better. Go to the the top left cell of where you are going to start linking the master xls, in the choices tab Select that cell Type the = sign Select the cell in the master XLS that you want linked Make the XLSForm active again Hit a return and the data from the XLS should be linked and appear. Select the linked cell, select the little + and drag it down for a total of 30 cells to link all of the protected cells in the master XLS. Here's where it gets dumb, because you would think that at this point you could simply highlight the cell with the link in it and drag it down the column to create the rest of the links in that column. When I do this it just copies the A1 link to the other cells and I get a column full of links to A1. So I change them all to A2, A3, A4..... A30. This is still much faster than linking each cell. Then highlight those 30 cells and drag them 4 columns to the right. So now in the B column all of your links are A1-A30, change them to B1-B30 Do the same for the remaining columns. If there is a way to do this more efficiently, please let me know.
... View more
11-18-2019
07:06 AM
|
2
|
1
|
1332
|
POST
|
But only the existing forms, anything new after building the master would a cinch.
... View more
11-18-2019
06:17 AM
|
0
|
0
|
1332
|
POST
|
I did figure out what the code I didn't understand was doing, at least enough to use it correctly in the new form I was building. It was the jr:choice-name(choice,'question') function that was confusing me. I found the "Description" in the ESRI documentation, but do not understand it 100%. I'll look for a more complete explanation, I'm sure there is one somewhere.
... View more
11-18-2019
05:59 AM
|
1
|
0
|
429
|
POST
|
Thank you sir, although I don't understand how it incorrectly adds numbers. I guess it's just a glitch, and an odd one at that. hehe and thank you for your patience with those of us that are still figuring it all out.
... View more
11-18-2019
05:35 AM
|
0
|
0
|
930
|
POST
|
YES WE CAN!!!!! Just did a test run with linked cells from a single source and it works!!!!
... View more
11-14-2019
12:39 PM
|
0
|
5
|
1332
|
POST
|
Great idea. I wonder if we can link cells in the XLSForm choices tab (or custom choices tab) to a master excel file?
... View more
11-14-2019
12:26 PM
|
0
|
6
|
1332
|
POST
|
All the instructions I've found so far say that the .csv must be put into the media folder.... So that .csv is only good for a single survey. Is there any way to force all my surveys to pulldata from a single source?
... View more
11-14-2019
11:30 AM
|
0
|
12
|
1753
|
POST
|
I'm still learning, pulling a ton of stuff off the interwebs and making stuff work. Looking back trying to tweak some of the functions in my older forms to work for new scenarios I'm finding some things, from before I started trying to document them, that I don't know what they are doing. Is there any way to follow the process, like tracing formulas in excel?
... View more
11-14-2019
08:12 AM
|
0
|
2
|
475
|
POST
|
Hey Mikaila, I'm actually not adding anything. The plus is not a mathematical plus. This is an industry standard engineering unit of measure called Engineering Stationing (ES). Whether you are engineering a highway centerline or a pipeline centerline the beginning point of the centerline is zero, expressed as 0+00. Ten feet down the centerline is expressed as 0+10. Think of it as another unit of measure where 100 feet= =1 ES, just like 10 mm = 1 cm. So 125 feet = 1.25 ES, but with ES we replace the decimal with the +, so 125 feet = 1+25 ES. 123,456 feet = 1234+56 ES, no commas. So, essentially it's a two-placed decimal, but displaying the decimal point as a +.
... View more
11-14-2019
07:04 AM
|
0
|
0
|
575
|
POST
|
James, I just thought of something. Could I use relevance, based on the number of characters input, to choose which mask is used? That way I could use a single digit mask, a 2 digit mask, a 3 digit mask and so on.
... View more
11-14-2019
05:56 AM
|
0
|
1
|
4208
|
POST
|
Is there any way to format an integer question so that regardless of the number of characters typed in, the result. is a two-place decimal with the decimal point replaced with a + sign? Here's what I need: input = result 1 = 0+01 (+01 or +1 would be acceptable) 12 = 0+12 (+12 would be acceptable) 123 = 1+23 1234 = 12+34 12345 = 123+45 123456 = 1234+56 1234567 = 12345+67 The mask function dictates the length of the string so is it possible to set a calculation in the relevance column that checks the string length, thus controlling the result to be the desired result??
... View more
11-14-2019
05:53 AM
|
0
|
3
|
999
|
POST
|
Thank you James, but we aren't hearing each other, for whatever reason. Nothing you've said addresses the actual question I have, even after clarifying and restating it again. You aren't getting what I'm saying and I'm not getting anything from your responses that actually address my question. No fault given, I just think we're on different wavelengths. I don't comprehend an "outline" of anything, but a vague restatement of my original discovery of the limitations of the mask and nothing hinting to whether there is any other way to accomplish what I am trying to do, and all I know to do is ask the original question in a different way. So forgive me for my frustration, but we are not communicating in a productive way, at all. I fully vetted what you have offered in your replies before submitting the original post and I thought it was clear that I was asking for a solution for the outcome I desired, any solution, or conformation that this is currently not possible. I guess, instead of the following, from the original post... So how do I put this into Survey123 for these results on these inputs? input 1 = 0+01 input 11 = 0+11 input 123 = 1+23 input 1234 = 12+34 input 12345 = 123+45 input 123456 = 1234+56 input 1234567 = 12345+67 I should have asked "Is there any way to format an integer question so that regardless of the number of characters typed in, the result. is a two-place decimal with the decimal point replaced with a + sign?". Actually that one sentence should have been the entire post. hehe
... View more
11-14-2019
05:43 AM
|
0
|
0
|
4208
|
POST
|
Hehe, I get this every now and then. With no more than 2 decimals input. Gremlins!!
... View more
11-13-2019
01:28 PM
|
0
|
2
|
930
|
Title | Kudos | Posted |
---|---|---|
1 | 10-16-2019 10:02 AM | |
1 | 11-18-2019 05:59 AM | |
2 | 11-18-2019 07:06 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|