topic Re: Calculate field from 2 forms in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-from-2-forms/m-p/858027#M25208 <HTML><HEAD></HEAD><BODY><P>No you cannot look across forms on the device.&nbsp; If you will be online then some people have been using javascript pulls against the hosted feature service.&nbsp; I have never tried as I am always offline.</P><P></P><P>You could do it in the web map using Arcade however, which I think is a better approach.&nbsp; This will not work in Collector yet as FeatureSet is not yet working for lookups - but it should be this year.</P><P></P><P>Another option is to launch from Collector and push the pickup form date to the disposal form.&nbsp; You could also add a URL to the first form that opens the second form and pushes the date and time.&nbsp; (You could open from Outbox or Sent box)</P><P></P><P>Hope that helps.</P></BODY></HTML> Thu, 09 Jul 2020 16:14:32 GMT DougBrowning 2020-07-09T16:14:32Z Calculate field from 2 forms https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-from-2-forms/m-p/858026#M25207 <HTML><HEAD></HEAD><BODY><P>Hi. We have 2 forms, one for truck load description at loading site, and a second form at disposal site. Date and time are automatically captured in both. Is it possible to calculate travel time by having a calculated field in the destination form which would search the matching record in the loading site form to calculate time difference</P></BODY></HTML> Thu, 09 Jul 2020 15:10:41 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-from-2-forms/m-p/858026#M25207 ReneAubut 2020-07-09T15:10:41Z Re: Calculate field from 2 forms https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-from-2-forms/m-p/858027#M25208 <HTML><HEAD></HEAD><BODY><P>No you cannot look across forms on the device.&nbsp; If you will be online then some people have been using javascript pulls against the hosted feature service.&nbsp; I have never tried as I am always offline.</P><P></P><P>You could do it in the web map using Arcade however, which I think is a better approach.&nbsp; This will not work in Collector yet as FeatureSet is not yet working for lookups - but it should be this year.</P><P></P><P>Another option is to launch from Collector and push the pickup form date to the disposal form.&nbsp; You could also add a URL to the first form that opens the second form and pushes the date and time.&nbsp; (You could open from Outbox or Sent box)</P><P></P><P>Hope that helps.</P></BODY></HTML> Thu, 09 Jul 2020 16:14:32 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-from-2-forms/m-p/858027#M25208 DougBrowning 2020-07-09T16:14:32Z