Subtraction

Submitted by btesec on Fri, 06/25/2010 - 3:56pm

HI Julian,

I have this one task:

I need to be able to add a on the fly:

Here is the scenario:

For a budget: funds are allocated for different projects/purposes. As funds are spent, entries are made against their allocated project fund. Users need to be able to view a screen/report at any time on what is the current balance and current expense/spent funds by project. So they can make some decisions based on the funds available.

This happens every year when new budgets are allocated.

I like formulize, but when It comes to calculation, in particular subtractions, I am stuck or nor sure how to accomplish it. Would appreciate your help here on how to go about this one.

Thanks,

btesec

‹ Your submission has triggered the spam filter and will not be accepted. Calculation against database data ›

Comments

I think you're looking at a PHP page

Submitted by Julian Egelstaff on Tue, 07/13/2010 - 10:18am.

Hello,

I think Formulize would be good for capturing the entries and their quantities. Then the only issue is totalling the number and subtracting that from some base budget.

You could do this maybe with a derived value field. Have a separate "budgets" form where you record the budget that things should be attached to, and then have a field in there which counts up the entries that have been made and does the subtraction.

Or you could write a specific PHP page that does the math. You can use the API to have Formulize return to you the outcomes of calculations you have specified in certain saved views. That's maybe over engineering this though.

It sounds like the kind of thing that needs some brainstorming frankly. I'd be happy to chat about this sometime if you want to talk through the options. Send me a number where I can reach you if you want.

--Julian

Thanks, Julian, I'll be

Submitted by btesec on Mon, 08/02/2010 - 3:43pm.

Thanks,

Julian,
I'll be contacting you soon, just finishing some stuff for this project then drop you a line for some help on this one.
Thanks again,

btesec