Transferring Data in Expression box to Text box

A

Andrea L

Hello,

I am still learning this program and have a dilemma I need help with. I have
read through a bunch of different threads but have not found anything that
really helps me. I'm hoping someone out there can help.

I have a form with a repeating table. In this table you enter a sku, a qty,
a price, and a discount. For each row in the table, I have field called
item_total that does the appropriate summing of the fields. At the end of the
table, I want to have a grand total that can be used in other places to
determine a grand total for an order. Right now, I have an expression box in
the footer that works great.

I have tried several times to have a text box I called item_subtotal, total
the amounts, but I can’t get any function I’ve tried to work. If I put that
text box in a repeating table, then the data is repeated and I still have no
total. The expression I have works great, but now I need to pass that along
to another field so I can get a grand total as I have other fields where a
person can enter shipping charges and order discount info.

Is there anyway to pass a value from an expression box to a text box? Or,
can someone help me write the correct function to make my textbox in the
repeating table work?

I’m not a programmer, so if you tell me to write code, please help me write
it. I can stumble through very easy stuff, but I’m not a pro by any means.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top