Hey, I have a smart table with, let’s say, 5 lines, and I now want a specific line update, A1 to a5 is numbered 12345, and I now want 3 (this is the key that Make knows which line in the table should be updated like a key at the data store) and in this line then change the text at c3 or switch/change the drop-down menu. How do I get that done?
(So in column A(3) the ID number / key is like the data store, I want to change line c3. )
Thanks in advance for the answer.
Hello and welcome to the community!
If I understand your question correctly, you first need to search for the value in the column that contains your key.
For example, if you want to update the row where column A has the value 3, start by using the Search rows module to look for 3 in column A.
Once you find that row, you can take its row ID from the search result and use it in the Update a row module to update the fields you need.
If you are worried about credit usage for multiple updates- you can try to get all values and then use the MAP() function- but this is a more advanced approach.
Hey, thanks for the answer, but unfortunately I don’t have the right modules to implement this. And I don’t know why. Do they not exist in general or only not with me? What I would need in modules would be these modules:
- List rows present in a table
- Get a row
- Update a row
Do you have these modules with you?
Hello @Marino,
If you’re using the Microsoft 365 Excel app, you should be able to use these modules: