How to calculate number of days between a date on repeat table one and repeat table two?

05-02-2020 03:38 PM
New Contributor III

Hi All,

I have created a form for survey123 connect mainly for stock management. I am struggling to do some calculations in the form so thought I'd rather perform them in my attribute table.

My service layer consists of: feature layer, order history table and inventory utilisation table.

I want to calculate the days between my deliverydate field that is within the order history table and issue date field that is within the utilisation table. It needs to be populated under Issued_delivered.

One delivery speaks to multiple issue dates. Hence I had to link a table to the order history to show the issue history. My problem is that I don't know how to calculate between two tables. I'm also not sure what the effect will be when a new delivery date is inserted.

The main purpose of this is to calculate safety stock, which will trigger a new order.

Therefore, I need the days between delivery and issue dates, this will allow me to calculate daily utilisation which in turn will help me calculate safety stock.

Please assist me with calculating between various tables in AGOL.

Much appreciated.

0 Kudos
2 Replies
Esri Community Team

Hi Liesl, Sorry on the delay. If you still need help with this or for future reference, I've also shared your question in to the ArcGIS Survey123‌ place where you can get info from other users and staff experts. Thanks for joining the community and let us know if you have any other questions! 

Esri Community Strategist
0 Kudos
Esri Esteemed Contributor

Hi Liesl,

It looks like this is primarily calculations after the form has been submitted, correct?  This might be a situation that would make use of Arcade's FeatureSet capability - that would allow you to query data from a second table in the calculation of another.  Take a look at the following blog posts:

What’s new with Arcade: Taking a stroll through FeatureSets (Part 1) 

What’s new with Arcade: Taking a stroll through FeatureSets (Part 2)