Using Formulas

Dan

August 12, 2016 at 2:32 pm #2431

Hi All,

Are there any pointers for ensuring SPARK UI formulas work consistently?

I built a common scenario with a Table, where each row represents an order line item.  There are columns for line item price and line item quantity.  Multiplying those, I calculate a subtotal for the line item cost and put that value into a third column in the table.  Likewise I total the subtotals from each row outside the table.  After that, I layer in costs for tax and shipping – all with Formulas.

When it works, it works great.  However it seems that things can stop working after making further UI edits and I’m not sure why.  I did some housekeeping like adding additional columns to the table, moving CVs around the screen, etc, and some of the Formulas no longer worked (the one that calculated the subtotal for each row, as well as the one that totaled the row subtotals).

I didn’t changed any of the formulas…any advice?  Maybe there are some fixes I’m not aware of or things I shouldn’t be changing after the fact?

Dan

 

jmac

August 13, 2016 at 5:20 am #2433

Dan:

It’s hard to say without seeing exactly what you have, but I suspect that when you were “moving CVs around” you may have inadvertently changed the address of one of the fields in your formula.  What you could try is to add a Configuration Control at the top of your page and click the debugging on switch, that will add to the console (hit f-12 to view in most browsers) and you may be able to spot the bad address.

I am aware of no issues currently or in the recent past with formulas.

 

Regards

 

JMAC

SPARK Support

August 15, 2016 at 9:52 am #2434

Hi Dan,

It looks like your formulas are set up correctly. Here is a reference to our article on Formulas https://salientprocess.zendesk.com/hc/en-us/articles/206348467-Formulas-

The problem with the controls not calculating was with the table configuration. Under the Columns Configuration option, all of the fields were set to render as Simple HTML. This meant that the tags were unavailable for processing. By setting the price, quantity and total to Seamless Coach View, the formulas are now calculating correctly.

Regards,

Stephen P.

Dan

August 15, 2016 at 11:37 am #2439

Yes, that made the difference.  Thanks!