I’ve put together an app for bee keeping which has main functions of Hive Inspections & Bee Yard Locations Management.
I’m struggling with one item at the moment. Our Hive inspection form has an area to record the number of hives. There are two different types so the user is adding a number for each hive type of “Singles” and “Doubles”. This is almost an inventory management function at this point as I want to display the most current hive total on the Bee Yard page. I don’t necessarily care what the previous numbers were as we are simply taking a fresh count at the time of the inspection and entering that as a new inspection form.
We can do multiple inspections a month so I always want the Bee Yard Location display page to have the latest total number of hives so we’ll need to only reference the latest inspection report values somehow.
I’ve messed around with actions and workflows and for some reason cannot get it to work. I’ve tried adding some virtual columns to create sums as part of the inspection report, yet I can’t seem to find a way to pass those values over to the location display page.
Any help/direction is greatly appreciated!