Hello Community! I’m having a hard time figuring out a formula to add multiple rows. I know this would use formulamap() and sequence() but I just can’t get my head around it. I made an example of what I’m trying to accomplish. It’s basically a formula that looks at how many variants there is for a …

I’m not getting it completely. Do you want the target table to have one Tshirt, then two more Tshirts, then 3+4+5=total 12 Hoodies, and 8 Vests? Why there are multiple rows with the same Product name then? I’m just curious if the complexity of the task can be reduced. This is in fact not so trivial…

Hi Paul, thanks for taking the time to look at this. I’m looking to send data from the Push table to the Result table. My example looks simple, but the tables wouldn’t look that similar in reality. This would be useful in our reporting if each item in each order was displayed as a separate row (1 o…

Sorry, still confused. Does the Result table need to look like the Database table in your example when all buttons are pushed? Is Variant just a piece of data that needs to be copied? Or is it the number of times the row in question needs to be copied?

No the Result table can be plain text and variant is just a piece of data for this example. The result table is all text, no lookups. I just want to split the product for each order. I edited the example to make things clearer. The shopify backend table is just used to created the products. This wou…

Okay. Well, I think the only way to implement that now is with a loop with an extra step to extract the Nth product in the list into a separate column. Here’s the formula for the button that would work: thisRow.Products.FormulaMap( RunActions( thisRow.ModifyRows(thisRow.[Loop - current produc…

UPD2: Just tried this and it worked. You can actually use a hidden _DEREF() function to get the values from CurrentValue where the latter is a reference to the product row: thisRow.Products.FormulaMap( Result.AddRow( [Order #], thisRow.[Order #], Product, _DEREF(CurrentValue, [Shopify Bac…

That’s awesome! This works like a charm. I thought the _deref function was sunsetted? If you have time (and i’m sure other users would like to know this) what does _deref do exactly?

I haven’t heard of it being sunsetted — it’s just an experimental hidden function I found a while ago. It may go away at some point though. _DEREF(input, column) means take the input and extract the column from it as specified by Table.Column notation. If not found, return blank. Think of it as for…

Thanks for the explanations! [image] Information on how to use _DEREF Hi @Ratish_Gupta , we actually sunsetted the _DEREF function, so unfortunately you cannot use it anymore in your docs neutral_face. On the org chart template, it’s running a different version of Coda wh…

Well, the function is still there :man_shrugging:

Formula Map Sequence + DEREF

Jay_Lefebvre November 5, 2019, 5:37pm 10

Thanks for the explanations!

Topic		Replies	Views
FormulaMap for creating multiple rows	4	3588	June 4, 2020
Button that creates multiple rows	16	5663	January 13, 2023
Add support for nested formulamap Product Feedback	2	1911	August 21, 2019
How to use formula map table rows information to create rows in other table	9	4862	June 23, 2023
Formula map merging new rows	2	1199	July 17, 2020

Formula Map Sequence + DEREF

Related topics