Expand my Community achievements bar.

Custom expense report

Avatar

Level 1

I'm trying to make an expense report and have two issues that I am working through.

The first is that we have two check boxes that determine whether an expense is project related and the other is whether the cost of that expense will be passed on to our customer. There are 13 lines for entering expenses. At the bottom of the form I am wanting to calculate company expenses and customer expenses separately. Right now I am using javascript in the company and customer balance due fields as follows. I am new to this..

form1.#subform[0].Body.CompanyBalanceDue::calculate - (JavaScript, client)

for i=0; i=12; i++

{

  if(ProjectExpense[i].rawValue == 1)

  {

    CompanyBalanceDue = MileageReimbursement[i] + Meals100[i] + Meals50[i] + OfficeSupplies[i] + EngSupplies[i] + MiscItems[i] + TrainingSeminar[i];

  }

  end if

}

end for

form1.#subform[0].Body.CustomerBalanceDue::calculate - (JavaScript, client)

for i=0; i=12; i++

{

  if(ProjectExpense[i].rawValue == 1)

  {

    CustomerBalanceDue = MileageReimbursement[i] + Meals100[i] + Meals50[i] + OfficeSupplies[i] + EngSupplies[i] + MiscItems[i] + TrainingSeminar[i];

  }

  end if

}

end for

My second challenge is that I want to make a submit PDF via e-mail, which is really easy to make if you want it to go to one user but I want the button to generate an e-mail to whoever's email address is entered into a text field.

Help is much appreciated.

Richard

0 Replies