Can any button gurus help out here? I have a table with rows that look like this: | Name | Quantity | Price | Schematic Symbol | | 10k Ohms | 5 | .10 | R1, R2, R3, R4, R5 | I would like to make a button for that row, that will basically look at the Quantity column, and make 5 copies of that row, …

Here you go @Michael_Forsman :blush: ! I’ve just slightly modified the Action within the button Condense and commented the changes I’ve made :blush: . [tbl.Parts] .Filter( And( Value = thisRow.Value, Rating = thisRow.Rating, Type = thisRow.Type, Status = thisRow.Statu…

Hi @Michael_Forsman :blush: ! Here you go :blush: … I’ve done it in 2 slightly different ways and depending on your current setup this might need some adjustments… The Action formula (which is commented) of the 1st button (the blue one) is: RunActions( // Step 1: Create a sequence (a list) goi…

Ooh thanks @Pch I’ll check this out ASAP and see if it will work!

OK this is great and gets me really close. But one problem I ran into (since I’m new to formulas and buttons) is that my actual table has slightly different columns than I gave in my example (to simplify things) and one of them (the Name) is actually a formula. It looks like the AddRow function exp…

Would you mind sharing a sample / mock-up doc ? :innocent:

Oh I think I may have misunderstood your syntax. Let me play with it some more here. I think I may have just been dumb haha

You can also simplify your formula using the new DuplicateRows() formula. Loop through a list of sequences numbers like @Pch demonstarted, and then simply set the quantity to the CurrentValue

Ok, good to know! I wondered if I could do that. I’ll play with that a bit here soon!

[image] Scott_Collier-Weir: You can also simplify your formula using the new DuplicateRows() formula. Old habits die hard :sweat_smile: … I completely forgot about DuplicateRows() :blush: Thanks for the reminder :blush: Here’s practically the same sample but using DuplicateRows() instead, j…

Thanks! So just to be clear, the difference with DuplicateRow is that by default, all the columns will have the exact same values as the source row unless specifically changed. Versus the other solution you had with adding new rows, if you didn’t specify a column, it would just end up blank? Do I h…

OK so I have updated my formula on my Doc and it’s working great! Here’s what I ultimately came up with: RunActions( Sequence(1, thisRow.Quantity) .ForEach( thisRow .DuplicateRows( thisTable.[Schematic Symbol], thisRow.[Schematic Symbol].Split(",").Nth(Curren…

Button to make X number of copies of row

Pch April 28, 2023, 9:12pm 9

Old habits die hard … I completely forgot about DuplicateRows()
Thanks for the reminder

Here’s practically the same sample but using DuplicateRows() instead, just to illustrate …

Just in case @Michael_Forsman, this topic helped me a lot when I was struggling with FormulaMap() / ForEach() :

Topic		Replies	Views
Button to duplicate multiple rows	10	3719	May 16, 2022
Button that creates multiple rows	16	5611	January 13, 2023
Adding multiple rows of data through a button via formula map	29	5200	July 14, 2020
How to use row ID for buttons? Showcase & Tips	2	871	May 25, 2020
Button to Delete Duplicates Tips and Hacks	15	5330	September 5, 2022

Button to make X number of copies of row

Related topics