calculate using text box

hye bob,i have a form to apply leave....what i want to make is like this...
1)[attachment=1]12.png[/attachment]
2)[attachment=0]13.png[/attachment]

how can i link the new current balance to be the total balance for the next time user login just as shown above?i set the total balance to 15 in a hidden field as u can see below....hope u can see a little tour on my form 😛 🙂

this is my form html

<?php
$user = JFactory::getUser();
$Id = $user->id;
$Name = $user->name;
$Email = $user->email;
?>


<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Leave Application Form</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Staff ID</label>
    <select class="cf_inputbox validate-selection" id="select_19" size="1" title=""  name="id">
    <option value="">Select here</option>
      <option value="<?php echo $Id ?>"><?php echo $Id ?></option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Name</label>
    <select class="cf_inputbox validate-selection" id="select_20" size="1" title=""  name="name_id">
    <option value="">Select here</option>
      <option value="<?php echo $Name ?>"><?php echo $Name ?></option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Email</label>
    <select class="cf_inputbox" id="select_21" size="1" title=""  name="email_id">
    <option value="">Select here</option>
      <option value="<?php echo $Email ?>"><?php echo $Email ?></option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Leave Type</label>
    <select class="cf_inputbox" id="select_5" size="1" title=""  name="L_leavetype_id">
    <option value="">Select Type</option>
      <option value="Annual Leave">Annual Leave</option>
<option value="Medical Leave">Medical Leave</option>
<option value="Unplanned Leave">Unplanned Leave</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Month</label>
    <select class="cf_inputbox" id="select_21" size="1" title=""  name="L_month_id">
    <option value="">Select Month</option>
      <option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_datetimepicker">
    <label class="cf_label" style="width: 150px;">From Date</label>
    <input class="cf_datetime" title="" size="20" id="L_datefrom_id" name="L_datefrom_id" type="text" />
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_datetimepicker">
    <label class="cf_label" style="width: 150px;">To Date</label>
    <input class="cf_datetime" title="" size="20" id="L_dateto_id" name="L_dateto_id" type="text" />
    
  </div>
  <div class="cfclear"> </div>
</div>



<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Total Days Applied</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_9" name="L_totaldaysapplied_id" type="text" />
  


<input value="15" id="L_totalavailable_id" name="L_totalavailable_id" type="hidden" />
<input value="" id="L_status_id" name="L_currentbalance_id" type="hidden" />

  
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Contact No.</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_11" name="L_contactno_id" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Reason(s)</label>
    <textarea class="cf_inputbox" rows="3" id="text_13" title="" cols="30" name="L_reason_id"></textarea>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Address</label>
    <textarea class="cf_inputbox" rows="3" id="text_16" title="" cols="30" name="L_address_id"></textarea>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_fileupload">
    <label class="cf_label" style="width: 150px;">Upload file(s)</label>
    <input class="cf_fileinput cf_inputbox" title="" size="20" id="file_17" name="L_upload_id" type="file" />
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">PM Details</h4>
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">PM</label>
    <select class="cf_inputbox" id="select_19" size="1" title=""  name="L_pm_id">
    <option value="">Select PM</option>
      <option value="E">E</option>
<option value="E">E</option>
<option value="P">P</option>
<option value="E">E</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>


<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">PM email</label>
    <input class="cf_inputbox validate-email" maxlength="150" size="30" title="" id="text_20" name="L_pmemail_id" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<input value="Unapproved" id="L_status_id" name="L_status_id" type="hidden" />


<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_21" type="submit" STYLE="font-size:8pt; background-color:00BFFF; color:ffffff" bordercolor="FF0F6F"    />

  </div>
  <div class="cfclear"> </div>
</div>

any1 ;(

Hi elyash7,

If you are saving the data in a database table you can load the new balances.

Bob

hye bob,

how can i load it....
im using v3 chronoform....
when i set the fixed value of total balance to 15....
then the value is fixed already....if i load it will comes out 15...
does i need to do sumthing on this?

hye,

i need some guide on this...
i already tried the mysql command but it oonly show in text...
can someone give me some guide or simple code and where to put it....

Hi elyash7 ,

I'm sorry, it simply isn't possible to design and code your application for you. Answering posts about ChronoForms already takes too much time each day.

The best way to desgin this is to use pencil and paper to write out the process flow and what needs to happen at each stage. Once you've done that the coding is much simpler.

Bob

im sorry...

but can u help me this one last time...
after this,i'll disable my account...

just this time ;(

Hi elyash7,

So, what is the process flow that you have written down?

Bob

hi bob,
this is my process flow...


[attachment=1]wwww.png[/attachment]

my form html,n whatever code i've given before in the previous comment above...

just that i want to get the current balance to be the total balance for next time apply for each user...this is my table..

[attachment=0]www1.png[/attachment]


thank u bob for helping me so much..

Hi elyash7,

I don't see any forms on there? Which forms are you using at each step and what do you expect them to do?

Bob

as u can see....my form html here...

<?php
$user = JFactory::getUser();
$Id = $user->id;
$Name = $user->name;
$Email = $user->email;
?>


<div class="form_item">
  <div class="form_element cf_heading">
    <h3 class="cf_text">Leave Application Form</h3>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Staff ID</label>
    <select class="cf_inputbox validate-selection" id="select_19" size="1" title=""  name="id">
      <option value="<?php echo $Id ?>"><?php echo $Id ?></option>


    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Name</label>
    <select class="cf_inputbox validate-selection" id="select_20" size="1" title=""  name="name_id">
          <option value="<?php echo $Name ?>"><?php echo $Name ?></option>


    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Email</label>
    <select class="cf_inputbox" id="select_21" size="1" title=""  name="email_id">
          <option value="<?php echo $Email ?>"><?php echo $Email ?></option>


    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Leave Type</label>
    <select class="cf_inputbox" id="select_5" size="1" title=""  name="L_leavetype_id">
    <option value="">Select Type</option>
      <option value="Annual Leave">Annual Leave</option>
<option value="Medical Leave">Medical Leave</option>
<option value="Unplanned Leave">Unplanned Leave</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Month</label>
    <select class="cf_inputbox" id="select_21" size="1" title=""  name="L_month_id">
    <option value="">Select Month</option>
      <option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_datetimepicker">
    <label class="cf_label" style="width: 150px;">From Date</label>
    <input class="cf_datetime" title="" size="20" id="L_datefrom_id" name="L_datefrom_id" type="text" />
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_datetimepicker">
    <label class="cf_label" style="width: 150px;">To Date</label>
    <input class="cf_datetime" title="" size="20" id="L_dateto_id" name="L_dateto_id" type="text" />
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Total Days Applied</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_9" name="L_totaldaysapplied_id" type="text" />

</div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Total leave Balance</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_9" name="L_totalavailable_id" type="text" />

</div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Current balance</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_9" name="L_currentbalance_id" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Contact No.</label>
    <input class="cf_inputbox validate-number" maxlength="150" size="30" title="" id="text_11" name="L_contactno_id" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Reason(s)</label>
    <textarea class="cf_inputbox" rows="3" id="text_13" title="" cols="30" name="L_reason_id"></textarea>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textarea">
    <label class="cf_label" style="width: 150px;">Address</label>
    <textarea class="cf_inputbox" rows="3" id="text_16" title="" cols="30" name="L_address_id"></textarea>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_fileupload">
    <label class="cf_label" style="width: 150px;">Upload file(s)</label>
    <input class="cf_fileinput cf_inputbox" title="" size="20" id="file_17" name="L_upload_id" type="file" />
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_heading">
    <h4 class="cf_text">Project Manager Details</h4>
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Project Manager</label>
    <select class="cf_inputbox" id="select_19" size="1" title=""  name="L_pm_id">
    <option value="">Select PM</option>
      <option value="xx">xx</option>
<option value="xy">xy</option>
<option value="c">ca</option>
<option value="xxc">xxc</option>

    </select>
    
   </div>
  <div class="cfclear"> </div>
</div>

<input value="unapproved" id="hidden_21" name="L_status_id" type="hidden" />

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="button_21" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>

i want it to calculate the current balance of the leave application...
user will key in total days applied and then the total leave balance will minus the total days applied to get the new current balance....

i want the new current balance to appear as the total leave balance for the nxt time the user apply leave....

just like you want to apply leave for your company...your maximum leave is 15....when u apply 3 days...it will become 12 as u have taken 3 days....

what do u need more for information....plz tell me....

Hi elyash7,

I want you to take your process map and work out what happens to the forms and tables at each step. Then you'll know what data needs to be saved or loaded and when.

Bob

ok,
does it possible to make it coded all in form html?
or else...

Hi elyash7,

🤨

Bob