Calculations using related fields fail in app

tendtreesTC — Mon, 12 Jun 2023 02:24:36 GMT

Hi There,

I have been building an auditing app in fieldmaps in which I have a layer for the site and a related table to undertake an audit on that site.

within the site layer I have built some calculations that work fine on existing sites however when I create a new site the fields return the error 'Failed to calculate' and won't let me submit.

I am assuming it is because there are not related records yet so it has nothing to calculate.

below is an example of one of the calculations to find the date of the last audit.

var fs = OrderBy(FeatureSetByRelationshipName($feature, 'WCC_Hort_Site_Auditing_XV2X_inspection_audit'),"CreationDate DES");

var feat = First(fs);

var result = iif(IsEmpty(feat['audit_date']),'',feat['audit_date'])

return result;

does anyone have a solution for this?

Re: Calculations using related fields fail in app

DougBrowning — Mon, 12 Jun 2023 13:46:22 GMT

If there are zero records I think this line will fail

var feat = First(fs);

What I do is check for no records a little earlier than where you did.

Not proper syntax but like this - check the count on fs first.

if count(fs) == 0 then return '' if not then return var feat = First(fs);

I am not positive you can return '' to a date field though may need to use Null.

Hope that makes sense.

topic Re: Calculations using related fields fail in app in ArcGIS Field Maps Questions

Calculations using related fields fail in app

Re: Calculations using related fields fail in app