I’m trying to set the value of a Custom Group to that of an Input on my page. Unfortunately I can’t see the Input I need listed in the Value field of Set State in the Work Flow. Is there a reason for this that someone can point me to? I’m thinking it’s pretty basic but I just can’t see it.
Here’s my input in design view - the CS is saved on the RG that the Input is in.
Here’s the Workflow - the Input (MSProdTotalAllRecipients) that contains the value I want to use isn’t listed.
I’d be so grateful for help in finding out how to do this.
It seems that your input is inside a repeating group!
What you are trying to do?
I’m trying to do a calculation. I tried with Texts but had no luck so thought they’d work better in Inputs.
Basically each line has details of an order on it (Product name, Quantity and Product Price).
I want to put a Line Total at the end which should be Qty * Product Price and then have a Grand Total of it all at the end.
This is getting really tricky because the Product Names are a LIST of Product names, the Qty are LIST of Qtys and the Prices are a LIST of Prices so I’ve had to display them with a “Join With Line_Break” which visually gives me what I want but now I’m trying to perform the total calculation and getting in knots because it’s more like an Array formula in Excel I think. I’m using a Custom State to act as the Array and trying to Sum it up but I can’t find the name of CS to refer to it.
(Thank you for reading this far…If you’ve made sense of my thinking, you’re a genius!)
If your Quantity and Product Price were a list of number (at least, that is what I understood), you can use the command :sum to sum all the elements of these lists.
Thank you for coming back to me. Apologies for the tardy response…
My main issue is that I want to set the value of the Custom States to whatever value is in an input but the Input doesn’t appear in the list to choose the Value from on the Set State page of the Workflow. Any ideas?
Yes, this is a common question around here 
The best option is to use a plugin to extract information out of your repeating group. You can check “Repeating Group Tool” (by BDK) or “Orchestra” (by Vini Brito). Both are very good and will do exactly what you need to.
I use the Repeating Group Tool (that is paid). Orchestra is free.
Repeating Group Tool:
Magic. Thank you ever so much for that. I’ll certainly look into it next week. I really appreciate your taking the time to help. Have a lovely weekend.
1 Like
