topic Re: It is possible to use pulldata or indexed-repeat in instance_name? in ArcGIS Survey123 Questions

It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Wed, 04 Jan 2023 01:50:44 GMT

I'm trying to access either parent data or data inside a repeat to label my inbox records. I've tried using indexed-repeat and pulldata in the instance_name field, but neither seem to work.

Is it possible to access related tables either "up" or "down" to label the inbox records?

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Wed, 04 Jan 2023 15:04:17 GMT

I have seen these types of issues with pulldata. Usually the workaround is to put the pulldata in a field by itself then call that field instead. Give that a shot.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Thu, 05 Jan 2023 03:11:25 GMT

Hmmm. I have not had any luck yet. Here is what I have tried so far as to put pulldata in a separate field.

- Use a note field with Bind null
- Use a text field with calculationMode (have tried always and whenEmpty). Even here it doesn't pick it up on the fly, but would if saved to the database.

Ultimately, I'm trying to get the data without having to save it in a new field in the parent/child form to avoid data duplication. Do you have any examples of forms this has worked for you @DougBrowning?

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Thu, 05 Jan 2023 15:02:12 GMT

Wait why would you use pulldata into your own form? Can you post the form or a sample form of what you are trying. Just like a mechanic you got to bring the car in. 🙂

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Thu, 05 Jan 2023 16:21:08 GMT

Sure. Paired down example attached.

(Yes, this survey is just repeat section. I'm trying to pull in data from the parent. I could add all the parent info to the survey, then I'd have to pull in info from the child also - that would be index-repeat method....)

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Thu, 05 Jan 2023 16:54:05 GMT

Is your WDiam getting populated in the form? It looks like you may be hitting an external service? Are you online when doing this? You mentioned repeats but there are no repeats in this form.

Sorry I am not sure.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Thu, 05 Jan 2023 23:10:03 GMT

Thanks for reviewing this Doug. I am not intending that WDiam would actually be a persistent field in this survey. This survey is the child table of a feature layer. WDiam is a field in the parent table. I'm hoping to pull WDiam from the parent.

I did find the post that mentions pulldata @layer should bring in my token, so I do actually need to change pulldata javascript to pulldata @layer.....

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Tue, 17 Jan 2023 22:35:26 GMT

Hi @DougBrowning - not sure if you saw my last response and had a chance to look at my form. Any ideas would be appreciated!

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Tue, 17 Jan 2023 23:39:47 GMT

I think you had lost me. You need the field in there if you want to use. Not sure how you can ref a field that is not there? If I need a parent field in a child I just add the field and call it RepeatNameFieldA then have a calc of FieldA to bring it into the child. We use it all the time on our keys and state code so we can filter at any level.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Wed, 18 Jan 2023 00:32:03 GMT

Ok thanks. I think I am missing a big concept on the parent/child. Using pulldata @layer must be overkill for bringing parent data into child - even when the parent data is not used in the form. I'll look into this.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Wed, 18 Jan 2023 14:50:04 GMT

If you mean pulldata inside the same form, then yes that is not the way to do it.

Here is a simple example on our photos form. Our dashboards and such all filter by State and Project to help our many crews filter down to just their items. We could do a bunch of arcade for it but then it is really hard to filter on Arcade fields. Also we use EvaluationID and not globalid (horrible choice) for all our relates later in SQL so we need this key in all tables. So we just add the fields we need at every level we need them, and it all becomes easy.

Main Parent section of form

Repeat child section of form. Note the simple calc to bring in the fields I need in the repeat.

Now is this double storing data - yes. Is that not great - yes. Is a pain to fix if they IDs are wrong - yes. Is it the only way offline - yes. In the end does it work well - yes!

Hope that helps

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Wed, 18 Jan 2023 17:04:53 GMT

Totally makes sense when parent and child data are in the form. My issues comes into play because I only have the child data in the form. I'm calling in the parent data (via pulldata @layer). I went back and forth about doing it that way. I was having trouble displaying only the most recently entered repeat to the field users.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Wed, 18 Jan 2023 19:53:57 GMT

When doing this I tend to use a launch URL from Field Maps or a web map that passes all the info I need into the child form. Workflow is use Field Maps to spatially navigate to the parent and get yourself there (Field Maps is better at the spatial side). Then tap the link to launch the URL and pass the keys and other info. At the point they are then linked.

To display the most recent that is build into the new map viewer now. You can show the last 1-10 records and sort them. May be an option for you. Me I have to use old map viewer so we can just hit show related and it works. You can also use Arcade and Feature set functions to pull any info you want from the children into the parent. I do this where I actually pull from a parent in a child then pass that info to the form.

We are always offline so pulldata is not an option for us. So not much experience there.

Hope that helps

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Thu, 19 Jan 2023 18:35:09 GMT

It does - thank you very much. The users really like the inbox list, but maybe there is some combination of using that and your workflow. Very helpful!

Re: It is possible to use pulldata or indexed-repeat in instance_name?

DougBrowning — Thu, 19 Jan 2023 19:18:49 GMT

You can create a link to launch a form in a form even. So use the inbox to get the parent - make it read only even better - then have a launch child in there.

Re: It is possible to use pulldata or indexed-repeat in instance_name?

JJ_Reyes — Thu, 19 Jan 2023 20:03:54 GMT

Interesting idea......!