Latest Contributions by joerodmey

To begin with I can provide screenshots/info you need ... View more

Hi Xander Bakker‌ The related table was created through the Survey123 repeat type. It appears that it uses parentglobalid as the relation. This relates back to the global ID in the parent. ... View more

Hi Xander Bakker‌, I get the following error: "Execution Error: Error" Am I pulling the ID properly here: "var id = $feature.objectid;" This objected reflect the object ID from the point feature service and not the related table ... View more

Xander Bakker This I what I have so far // first read out the ID of the Feature1 var id = $feature.objectid; // access the table Feature2 var tbl = FeatureSetByName($datastore,"Work"); // create a sql expression to query on ID var sql = "ID = '" + ID + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // count the resulting records var cnt = Count(related_data); // initiate a variable to hold the result var result = cnt + " related records"; // check if there are related records found for the current ID if (cnt > 0) { // loop through related records for (var row in related_data) { // read some data and create the line you want var line = TextFormatting.NewLine + " - " + row.Item; // add the line to the result result += line; } } else { result = "No related records:"; } // return the result return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Some info on my data: -Related table is called "Work" -Within related table I want to pull the data in field "Item" -From the "Item" field I want to take that and multiply it by 2.5 -Need to do this for every point i have in my feature service and show it as a new field in the popup -Will then take that value and pass it into Survey123 using the custom attribute disapy and the custom URL to send to Survey123 -Not common to have multiple related records on one feature service point but it can happen sometimes ... View more

Hi Xander Bakker‌, I'm looking to do something similar with Arcade. I have a feature service with related table. Within the related table I want to pull data from one field containing quantity and I want to multiply this by 2.50 as this is the price. The result would the value I want to use in my popup. How would I accomplish this? Thanks ... View more

Perfect. Can the feature report template accept calculations? For example just say I want to pull in a quantity value and a unit cost value. Can I tell the template to calculate the total cost using those values and simple multiplication? James Tedrick‌ Thanks ... View more

Zachary Cravens What was your workaround? ... View more

Thanks James Tedrick and Yulia Mamonova‌ I'm also looking at including related records (from a repeat in my form) within the report. Have either one of you accomplished this? ... View more

I believe that you have confirmed my thinking. Do you have another idea or do you need more info? ... View more

Hi James,   I’ve tried numerous times using once() in calculation field and the expected behavior doesn't occur. My code is:   once(if(${Request_Status}='In_Progress',once(${user_status}),"))   Thanks ... View more

So far Ive been testing with the editor tracking aspect of the feature service and seems to accomplish what i'm looking for. Will report back once testing is complete ... View more

Can we push this bug into implementation? Or do you have a workaround? I just need a way to update my feature services and the indicators in my dashboard ... View more