Latest Contributions by ToryChristensen

Hi all, I'm currently using FME Desktop to extract data from an SQL server and then amend a AGOL feature service, to ensure the feature service is updated. While this works, its a manual process and that limits how often the feature service can be updated. I was hoping that there was a way that I can use Notebooks instead of FME Desktop, and also take advantage of the scheduling functionality to update the feature more often. I'm slowly learning Python, but wanted to check whether Notebooks would be able query an SQL database. Thanks in advance ... View more

Hi all, I'm using a mixture of Survey123, Workforce, Dashboards and now Power Automate to coordinate the classic asset inspection program i.e A few thousand assets that are inspected a few times a year on no set schedule. Currently I have been passing an asset ID from Workforce to Survey123 using a custom URL, than then triggers a pulldata to populate the assest's information, such as name, location, owner, etc. This has worked well, but its always been annoying that I cant define the relationship between the asset and the inspection. I have an asset layer and an inspection layer, and a number of power automate flows that update layers with data, such as adding a last inspection date from the inspection layer to the asset layer... not ideal! Recently I've learnt about how you can use repeats to create a relationship between asset and inspection and now I'm  transforming my data to create the thousands of asset surveys, ready for the inspections (the repeats). Using the asset inspection model as described, can Workforce launch a specific survey? Or does it require the workers to get to the work site, then manually find the right survey? Assistance from people who have overcome this would be greatly appreciated 🙂 ... View more