[SOLVED] Updating Database User-Specifically: Is it Possible?

Ask the community
,
1

I want to display distances between the user’s location and the searched location in a repeater. In the repeater should be the corresponding text line with the number of kilometers for each location. I have already finished the functions for this. Now my idea was to insert the calculated data into my database using the insert() method and then connect a text line with these values. But it occurred to me that it would be a problem if several users would do the same and stand in different places.

My question would be if there is a way to update the database user-specifically without affecting other users. Or is that not possible?
If it is not possible, can anyone think of a solution how I can assign the distances to the respective location (element) in the repeater without linking to the dataset?
Or does anyone have any other ideas?
Thanks in advance

2

After two days I managed to find a solution. I have manipulated the repeater items with Velo code using the .forEachItem() method.

I called my repeater like this:

$w("#repeater1").forEachItem(($item, itemData, index) => {

                    const item = results.items.find((result) => result._id === itemData._id);}

So it checks if it is the same repeater item.
Then I created a variable and assigned it to my text element I wanted to manipulate:

let repeatedTextElement = $item("#text1");

repeatedTextElement.text = formattedDistance;

But I couldn’t find a solution for how to create a custom database column.