I want to show a screen when a user gets closer than forexample 700m to cordinates registered to an item in the database. The screen should ask the user, a yes or no question. if yes, update the timestamp on the item to “Now” if no delete the item. Or forexample after x amount of users answered no delete the item.
This column calculates the distance “How the crow flies”
This column calculates this distance if you were to travel by road (under calculate distance)
Yes but for the one made by radar, i need to set an origin. i do not know how to set the origin to the users current position, and ofc it needs to keep updating live.
Would the Distance column not be sufficient enough for what you need? Only difference is that it’s straight line distance, but we are talking about 700m here, so I wouldn’t think distance by road is necessarily important just to use for conditions.
The distance Column is what i currently use, and it works fine. The real problem is. How can i show a screen/overlay when a user enters the 700m radius and then let then let them click yes or no to a promt saying something like “was this warning correct?” yes no, if yes update timestamp to “now” if no, delete that item. i also tried to make it so that if there is an item within 1000m, a red blicking card warning them about the item forexample an animal in the road, but i have a problem with that also, since it only works on the item first added to the table. @Jeff_Hager
Maybe i could screenshare and show it to you, kind of hard to explain in text haha
It depends on how your data and screens are structured. Screenshots would definitely be useful, but it sounds like you are making a Google Maps or Waze style app to report hazards on the road to other drivers.
You can’t automatically trigger an action based on the distance changing, so getting an overlay to pop up won’t happen. But an initial thought would be to have a custom collection sourced from the table that contains the distance, but filter it to only show items with a distance less than 0.7km. When you get close enough, those items should show up in the custom collection. Inside the custom collection container, you can add buttons.
Another thought is to have a Query column that finds items with a distance less than 0.7km. Then add a Single Value column that gets the first matching ‘Whole Row’ from the query. Then you can display buttons on a screen based on the query being not empty, and you can set up your buttons to Set Columns or Delete Row directly through the Single Value → Whole Row.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.