General

Re: Get data from repeating section field into another field

dunc85 — Thu, 29 Apr 2010 11:38:40 GMT

Managed to open the updated form and it works great, thanks for your help.

Re: Get data from repeating section field into another field

dunc85 — Thu, 29 Apr 2010 11:24:43 GMT

Hi,

would you be able to explain what you did? As I couldn't see what it was doing (it didn't seem to bring the costs from 3.3 to 3.6).

Thanks for your help so far.

Edit: it could be my fault, when I open the file, it's showing the location as the location of the original file. So I think it may be opening the old one.

Re: Get data from repeating section field into another field

Qazi Anis — Mon, 26 Apr 2010 14:40:08 GMT

check the attachment, i have done it for you.

n sorry i misunderstood your question

Re: Get data from repeating section field into another field

dunc85 — Mon, 26 Apr 2010 14:17:04 GMT

Hi,

I may be misunderstanding you. But, I don't need a total of the values that will be entered into field235.

For each option (i.e. a new section in the repeating section), I need to take the total (field235) and insert it into the corresponding row in the table in Section 3.6.

E.g. the total cost for option 1 (from Section 3.3) will go into field201.

the total cost for option 2 (from Section 3.3) will go into field205.

and so on.

Re: Get data from repeating section field into another field

Qazi Anis — Mon, 26 Apr 2010 12:45:57 GMT

use

sum(../my:group20/my:group21/my:field235)

formula to calculate the sum of the fields.

Get data from repeating section field into another field

dunc85 — Mon, 26 Apr 2010 09:36:44 GMT

Hi,

I have created a form (attached) to allow users to submit business cases.

Section 3.3 is a repeating section which holds costs data. Users can insert a new section to allow them to enter costs for a number of different possible options.

Is it possible to get the total cost for an option (field235) and insert it into the appropriate field in section 3.6 Value for money appraisal?