Looking to hire someone to build this solution for us. Please message me with an estimated cost to do it, so that I don’t waste your or my time.
Goal: When an item is created on one board (via form), I’d like to post the info of 3 columns as an update into a corresponding Item on another board.
Background: Our landscaper can fill out a form to let us know they mowed a particular house. The data they submit includes date, location (geo tag) and pictures (files). This data comes in to a board/group.
On a separate board we have the list of properties that need mowing. One column is a location column (geo tag).
Desired Outcome: Every time a form is submitted, the geo location is checked against the existing geolocations in each item of another board. Where two location columns match, that’s the item that will get an update with a pre-written text saying something like “On MM/DD/YY this location was mowed” and then attach the submitted files to the update.
The idea being that different landscapers will continue sending updates that go into that board that functions as a log. And on the other board we track all updates in one Item for that particular property.
We have integromat and zapier accounts, assuming that’s the way to do it. Or is an App the solution for this?