Hi
coming from usual database sql language
i don’t find how to update the exact cell.
example
select A where B=no (limit 1)
it doesn’t return the exact line number
so impossible to update the cell with B = yes
sheet update input is only the raw number, but I don’t have it from the search module
the current raw return is always 1 but it is not the real row number 1.
hope i’m clear
in fact missing to get from the sheet search the row number of the selected record. any idea ?
Hey there,
can you share some screenshots of the sheet it self and how the module is setup at the moment?
sure.
last I did a delete record.. this works because as you see first record has C = no, so the delete is always on the first record, but i want to keep the records instead of deleting and flag to yes.
here the problem is the select will return the first record with C = no , which will have value bundle position 1, which is the first records with filed C=no but the second record in fact, so if I update cell row id : bundle position it will always update the first raw and not the one.
in sql I would have updated by id PK of the table.. or update from x set C=yes where name =”x” or id = 1. the issue here is the update is only on a raw id, can’t be a clause where
You don’t map the bundle order position in the Row Number, there has to be a Row Number variable coming from the Search module. The bundle order position will always be 1,2,3 and so on.
Ho no look the screen, bundle order position = 1 doesn’t mean row 1 but row 1 of the filtered request. so as there is a clause were.. you can select records starting at row 10 (if rows before have C = yes), but row 10 will return bundle order position 1.. as you see no row number returned
You are probably using the wrong module.
Try using the “Search Rows” module instead of the “Search Rows (Advanced)” module.
Hope this helps! If you are still having trouble, please provide more details.
— @samliew
exact… thanks. strange that the advanced doesn’t return the row id
No problem, glad I could help with "Select and update record"! 
The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep this forum organised. 
This marks the topic as solved, so that others can:
To do this, simply click the checkbox at the bottom of the post that is the most helpful in answering your question.
Here’s a magic link to a list of your other “unsolved” topics:
status:unsolved
Do bookmark this topic so you can easily find and return to this topic in future.
/my/activity/bookmarks
Creating a new topic for each question makes it easier for others with the same problem to search for answers. You are also more likely to receive help sooner as new topics are displayed first on the forum’s “new” page!
Hope this helps! If you are still having trouble, please provide more details.
— @samliew
