Check box and formula
Hi - i have a choice box regards to how im to bill a customer 1. to invoice. 2 to deduct from their credit on account.
i have built a system so one takes away from another, but i want a checkbox that if its ticked then it will do one of either, not just the just the same every time
3 replies
-
Add your checkbox (I've called it Chk1)
StatusName is the name for your field what ever you called it
in the trigger after update
if Chk1 = true then
StatusName := 1
else
if Chk1 = false then StatusName := 2 end
endI 've done this long hand but you can use "Yes "No" .... True False. 0-1
ie
if Chk1 = true then
StatusName := 1 else StatusName := 2 end
As usual there are several ways you can do this.
Mel
-
Just to clarify - StatusName is my name for your choice field Name
-
Hi Mel thanks for your reply -
what i need it to do is in the check box, if i click "hardware" then the value of the order id deucted from the shown harwdare balance (which is a hardware credit Vs a purchse) as shown. If i click the checkbox to "invoice" the value isnt deucted from this shown equation. thanks
Content aside
- 4 yrs agoLast active
- 3Replies
- 445Views