How to use a button to duplicate visible rows only

1

Hi all,

I’m still very new to Coda so please forgive me if this is a daft question, or in the wrong place, or anything else :slight_smile:

I’ve got a table that’s being used to track incoming statements/invoices for specific periods, from specific sources, etc.
What I’d like to be able to do is to have a button that duplicates all visible rows and overwrites the value in some of the fields. For clarity, is a user filters the table to only show statements from source X for period Y, I only want the button to duplicate those rows (without anyone needing to amend the formula each time).

Any help would be greatly appreciated!

Thanks.

2

Dear @Brendan_Jack, welcome to the Coda Maker community,

A good practice to get tailored support will be to share an sample without sensitive information but that presents your use case as much a possible.

The dynamic sections, like date ranges, doc types will be included by adding the (multi) select in the formula, so it adapts itself to the criteria selected.

Instead of duplication of information, I would recommend to create (dynamic) view(s)

This video explains well how to create buttons to duplicate rows:

3

Hi all,

I’m still quite new to Coda, so apologies if this is a basic question, or if it’s in the wrong place. :blush:

I have a table that’s used to track incoming statements and invoices for specific periods from specific sources. What I’d like to do is create a button that duplicates all the visible rows and then overwrites certain values in specific fields.

For example, if a user filters the table to only show statements from Source X for Period Y, I want the button to duplicate just those visible rows without needing to update the formula every time.

Any help or guidance would be greatly appreciated!

Thanks so much!

4

Hi! Were you able to check out the video suggested by @Jean_Pierre_Traets? Sharing an example doc of your progress thus far is also helpful! :smile:

5

Hi @Jean_Pierre_Traets and @James_Malloy

Thank you for the video! Besides being helpful it also inspired me and I’ve landed on the following (which serves my purposes far better than what I had originally planned): -

[Table 2].Filter(Checkbox=true).FormulaMap(RunActions(AddRow([Table 3],[Table 3].Name,CurrentValue.Name,[Table 3].[Column 2],CurrentValue.[Column 2],[Table 3].[Column 3],CurrentValue.[Column 3]),ModifyRows(CurrentValue,[Column 2],“”,[Column 3],“”,Checkbox,false)))

What I’d like to know though, is how I can have the above formula filter table 2 for ticked checkboxes as well as whatever the active filters in the table 2 filter bar are, for example, if I only wanted to add the rows where the checkbox is ticked AND column 2 = whatever value I’ve got the table filtered on (24M02 for example, so only the bottom three rows are moved to table 3

image

Thanks for your help!

6

Hello @Brendan_Jack ,

Although you need one extra step to do this, you would be surprised how easy this can be accomplished.
Step 1) make a view of your table.
Step 2) add some filters to the filter bar
make a button with the following formula:

DuplicateRows([View of My_Table].Filter(checkbox))

Please not: if you want only the visible rows with the checkbox ticked, you don’t have to type checkbox=true(), just typing checkbox will suffice (if the name of the column is checkbox).

Using the formula above duplicate the visible rows in the filtered table, but only if the checkbox is ticked.

This only works with a view of your table not if you are using your main table. Generally speaking, you want to keep your main table somewhere else in your doc (like a hidden page with all your main or source tables). If you use the above formula on your main table, all rows with a ticked box (visible or not) would be duplicated,

7

Thanks! This is very helpful! :grinning: