topic Re: Any similar function to pulldata() to work with MMPK? in ArcGIS Survey123 Questions

Any similar function to pulldata() to work with MMPK?

lannguyentl — Sun, 09 Jul 2023 21:33:06 GMT

Hi All,

A linked MMPK in a survey form is so useful for offline basemap. However, will be much better if there is anything similar to pulldata() to work with the mmpk, such as pulling data under geopoint from mmkp to populate other fields while offline...

I believe many member in this community share the same thought with me.

Thanks!

Re: Any similar function to pulldata() to work with MMPK?

MarkWILSON_LLS — Mon, 06 Nov 2023 04:05:48 GMT

Gday there @lannguyentl . Yes I am after this exact feature.
I replied to another thread a few weeks ago along similar lines, (https://community.esri.com/t5/arcgis-survey123-ideas/select-features-in-survey123-map-geopoint-question/idc-p/1341784#M2685)

the end goal is to have pulldata(@layer) functionality in an offline setting (without having to use a URL link from FieldMaps etc)

Re: Any similar function to pulldata() to work with MMPK?

PegGronemeyer1 — Mon, 06 Nov 2023 14:06:32 GMT

Greetings -

@lannguyentl and @MarkWILSON_LLS

I also would love this - pulldata gives me the exact function i need, but I can't go offline with it.

You have my upvote

Thanks

Re: Any similar function to pulldata() to work with MMPK?

MarkWILSON_LLS — Mon, 06 Nov 2023 23:28:10 GMT

FYI,
My current workaround for this is to have the pulldata(@layer) fields added as a note type linked to a geopoint field.

Process for offline collection:

1- Open the survey form and collect the GPS geopoint field - Note fields for reserve name, area etc are all unable to populate as the device is offline

2- Fill all fields and save the survey to the outbox

3 - When back in service/online, edit the survey from the outbox. without editing any fields the GPS Geopoint will now update all the pulldata(@layer) calculations and populate the note fields for reserve name, area etc.

4 - Submit the survey from the outbox.

Re: Any similar function to pulldata() to work with MMPK?

PegGronemeyer1 — Mon, 06 Nov 2023 23:30:26 GMT

I appreciate this so much! Thank you

Re: Any similar function to pulldata() to work with MMPK?

lannguyentl — Tue, 02 Apr 2024 20:47:52 GMT

Hi All, sorry for being offline for awhile.

In Sep 2023, I talked to Ismael Chivite when he came to NZ for our User conference, and he promised to have this function in 2024 🙂

@Ismael

Has anyone heard anything yet?

Thanks,

Lan

Re: Any similar function to pulldata() to work with MMPK?

SteveBrewer — Wed, 03 Apr 2024 05:33:44 GMT

Hi Lannguyentl. This would be a great feature and sorely needed. I will be testing a javascript that will do this function offline tomorrow with a json. If it works I will share it with you here as a fix until esri can provide this.

Re: Any similar function to pulldata() to work with MMPK?

lannguyentl — Wed, 03 Apr 2024 23:52:17 GMT

Thank SteveBrewer!

Re: Any similar function to pulldata() to work with MMPK?

MarkWILSON_LLS — Fri, 13 Jun 2025 01:53:16 GMT

Hey @SteveBrewer , Did you ever make any progress on the java/json approach to this?

many thanks

Re: Any similar function to pulldata() to work with MMPK?

PegGronemeyer1 — Fri, 13 Jun 2025 13:48:53 GMT

In case it helps anyone - you can use pulldata offline using external CSV. I hadn't realized this for over 2 years as everything said "pulldata doesn't work offline". Now I know it is not technically true. Most of our work is offline. I have a csv with structure ID, lat/long, etc. Using select_one_from_file the user in the field selects the structure ID (which is in the CSV). Then the pull data function in calculate field pulls from the CSV to populate other questions, e.g. county, structure type, etc.. I have not yet been able to pull the lat/long into the geopoint via a concatenate of the lat/long from the csv, but I think it is me being stupid b'c there are postings that seem to suggest it is possible.

Re: Any similar function to pulldata() to work with MMPK?

MarkWILSON_LLS — Wed, 25 Jun 2025 01:26:50 GMT

Hi all.

I've also had some success with the external CSV option in the last week too.

Ive extracted a copy of our reserves dataset to a csv and incorporated a geometry field in there where I've loaded the json geometry rings.

- all the fields can be loaded via pulldata('CSV')

- Use a note field to bring in the geometry as json

pulldata('CSV','geometry','name',${ReserveSearch})

- read the json geometry to the geoshape using

pulldata("@json", ${geom_json},"geometry")

You can also use an online+offline toggle using coalesce() where you'll pull online data into a field as the primary source, but if offline, it will pull from CSV.

NOTE geoshape fields only honour singlepart features - Ive been attempting to get multipart to work but there's nothing on this front at the moment.

Re: Any similar function to pulldata() to work with MMPK?

MarkWILSON_LLS — Wed, 25 Jun 2025 02:04:03 GMT

I have not yet been able to pull the lat/long into the geopoint via a concatenate of the lat/long from the csv

I think what you'll need to do for this to pass through and populate a geopoint geometry is to update your local csv to include a field that stores the lat/long in a json sting.

Ive got this working for singlepart polygons into a geoshape, but just not sure on the exact syntax for geopoints.

have a look at this post for what looks like it'll work for geopoint

https://community.esri.com/t5/arcgis-survey123-questions/calculating-a-geopoint-from-a-feature-service/td-p/1006507

Im potentially going to try this in leiu of geoshape not working with multipart features.