Database Logic and management

Need help Database
1

Hi everyone, Hope someone can help me in this regard.

I have this database structure:
User who can have list of clients
Client who can have list of documents
Documents which are in text formats

in my app page, i have a table which shows the list of clients
user can select a client to see clients’ documents
then there is a table which shows the list of documents from one client
User can see each document text by clicking on its icon and a popup shows the text.

now i want to give this option to edit the text of this document and replace the previous text with the edited one.

for saving this change, i think i need to use make change to a thing…, but i could not figure out how to do that.

I have this, but every time it just edited the last item, i do not know how to determine which item exactly should be replaced.

Screenshot 2025-03-21 at 13.40.01
Screenshot 2025-03-21 at 13.40.011718×1160 83.8 KB

2

Since the list of documents are inside a repeating group, I’d suggest using the current cell index as the item to edit.

So something like ‘Search for Documents:item#current cell index’

I’d have to replicate this issue in an editor to be sure, but something along those lines.

Or when you click a document you could set the url parameter to be a number and the number would be the selected cells index and then you use the url parameter as a reference point for the cell to edit

3

Since this is an API endpoint, why don’t you simply pass the Document to edit as an argument? No need to use a Do a search for expression.