• Resolved Ranger6

    (@jedwardg)


    I’ve got a simple site that is only going to be live for 3 months. I need a single form that every user can access that will have maybe 6 line items that will accept user input in the form of a number. I then need to keep a running total for each line item, so there will be 6 calculation fields. I need these 6 calculation fields to be persistent and the 6 line item fields where users enter numbers to not be persistent. So, for example, every time a user accesses the form, the 6 line items are 0. Then, user1 enters 3 for line item1, 5 for line item3, & 2 for line item4. The calculation fields would be 3 for item1, 5 for item3, & 2 for item4. User2 accesses the form and (all line item fields are 0) enters 5 for line item1, 5 for line item2, & 3 for line item4. The calculation fields would now be 8 for item1, 5 for item2, & 5 for item4….and so on.

    Is this possible with this plugin? Again, very simple, short-lived site, I don’t need any bells and whistles. I’ve just started playing around with Calculated Fields and so far I like what I see. If the above can be done, I’d very much appreciate any quick tips. Thanks

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @jedwardg,

    Not by default, you would need to implement this behavior as part of your form.

    For example, the Developer and Platinum versions of the plugin include the set of “DS” fields (fields whose data are read from an external data-source, like a database or CSV file). You will need to insert a “hidden DS” field for each row to read the last value submitted for the corresponding calculated field from the database, and use this “Hidden DS” field in the equation associated to the calculated field of the row where it belongs.

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘persistant total’ is closed to new replies.