0

Ability to Add Formulas to Headers or Free Text layout fields.

I would like the ability to add formulas to headers and free text fields. For example, if a customer has overpaid their invoice, I can have a popup that says "NOTE: Customer has overpaid $__ for this work order. 

6 replies

null
    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    Hi, you can solve this with a formula field. Use an if/else statement.

    Best regards, Alex

    • Support
    • 5 yrs ago
    • Reported - view

    Hi, you can use the alert("some text") function for that.

    You can put it in the trigger field "Trigger after update" of the paid amout field. Please see also our user manual for more detailed information https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

    Best, Jörg

    • SMoore
    • 5 yrs ago
    • Reported - view

    I am aware of the formula field, though a Free Text field would be more visually appealing. 

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    With a trigger, you can write the value into a text field

    • billetcnetwork
    • 5 yrs ago
    • Reported - view

    How to print a report with a total. For example. Total amount of Purchase price.

    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Bill, 

    You can use a formula field for that and enter a formula of that kind: 

     

    sum(MyTable[condition].Price)

    It depends on the database structure how the precise formula has to be.

    You are invited to join our webinar, then we could give you a live support there.

    Please register for the webinar here: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg

    Best, Jörg

Login to reply

Content aside

  • 5 yrs agoLast active
  • 6Replies
  • 2430Views