Modify Row Button Based on Unique ID

1

Hi Coda Fam
I have two tables. Each row in Table 1 possesses a unique ID. Each row in Table 1 has the ability to create a row in Table 2 that contains that ID. I am trying to add a button to each row in Table 1 that modifies the row in Table 2 that shares the same ID but have not been able to figure it out. Here is what I have tried-

Add Button
Action- ‘Modify Rows’
Table- ‘Table 2’
Apply To- ‘Custom Filter’
Customer Filter- ‘Lookup([Table 2],[ID],Table 1.thisRow.[ID] )’

I also tried
Custom Filter- '[Table 2].Filter([ID]=thisRow.[ID])

Any thoughts?

1 Like
2

Hello Matthew,

Take a look at this, thanks!

2 Likes
3

This is perfect! Way easier than I was trying. Thanks!

4

I tried to set up this exact thing and it’s sadly not working :(. is there a bug or something preventing buttons from doing custom filtering?

5

Dear @Londya_E,

You will be able to copy both tables from the sample of @Bobby_Ritter and paste in your own doc and after that edit it to your own needs.

But, I have the feeling that you intent to do something else, since you mentioned:

If you doc doesn’t contain sensitive data, I recommend to share the doc to get the best support meeting your requirement.

6

Hi @Jean_Pierre_Traets , I just figured out the problem why t wasn’t working for me, but I still need a solution. I’m going to share an example of what I need help with in a few seconds. Hang on a minute.

8

EDITED: Nevermind! I figured out a different way to get it in there without the button, but thank you if you tried!!!

@jean Here is the use case. I would like to update my client list with the latest food bank delivery entry date. I need a custom filter on the button that searches the client list by client name using the list of client names in the food bank delivery log, but I’m having a hard time figuring it out. Can you help me with this?

https://coda.io/@londya-e/copy-of-updater

Whoops forgot to publish the doc

I tried .contains() and Lookup() formulas…they keep trying to update all rows.

9

Dear @Londya_E,

Please have a look at my take on your doc and if this is what you are looking for

:bulb:
When you make a copy of it, you will be able to see the formulas

10

Hi Jean,

The use case you created didn’t exactly work for what I wanted because the end goal was getting the last food delivery date into the client profile list. I guess I confused you because I ended up figuring out that I could just use a formula in the client profile list to get the last delivery date. I probably should’ve created the solution I ended up finding on my own in another doc.It was just easier to figure out there without messing up all my important info. sorry for the confusion. Thank you for you time and your help.

At least I know for next time what to do though. This is my first time asking for help in here.

1 Like