Can data be transferred to a custom record format automatically? I am trying to use the Manage Database tool to move data from a record (valve or hydrozone) to another record created using a new record format tied to a database. This approach is challenging and I have not had success. The goal is to be able to use the collected data in a worksheet for various calculations. I have tried manipulating worksheets but it seem the object types don’t work together. Presently I manually fill in the info
OK. I think this does what you want. It was more complicated than originally explained because some of the Hydrozones actually have multiple areas that have to be summed together.
Copy everything thing in the code block below and paste it into a new blank Vectorscript editor window named "SumField2FromField1Match"
In the Database header row enter a formula of:
=RUNSCRIPT('SumField2ForField1Match', 'IrrigationHydroZone', 'Hydrozone Name', 'Area', B17)