0

Formulas

Hello,

When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find: X" when searching a specific word/name associated with a formula field?

- John

62 replies

null
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    Hi Andrea,

    if today() > ‘Data scadenza fattura’ and text(‘Status fattura’) != “Pagata” then ‘Status Fattura’: = “Scaduta” end

    regards
    Leo
    • Andrea
    • 6 yrs ago
    • Reported - view
    are you sure? it doesn't work
    a pop-up says: in Italian "Questa formula potrebbe non modificare i dati"..
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view
    that's right, the calculation field is not allowed to make any data changes.
    You should create your formula as a trigger "after update" in the 'Data scadenza fattura' field. Or as a formula in the Button.

    https://www.dropbox.com/s/r82as6qfnaquupd/Andrea.ninox?dl=0

    regards
    Leo
    • Andrea
    • 6 yrs ago
    • Reported - view
    Hi Leo,

    now it works as formula trigger, but not automatically. I would like the function to work automatically every day: checking if the date in the "Data scadenza fattura" field is before today's date and modifying the combobox. Is it possible that it works like this? This is a function that checks whether the payment date of an invoice has expired or not. THX
    • Andrea
    • 6 yrs ago
    • Reported - view
    Hi,
    where can I find the list of icons names?
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Here:
    Iconset.ninox


    Birger - Ninox Support
    • Andrea
    • 6 yrs ago
    • Reported - view
    Hi!
    How to reset the ID counter to 0? Or how can I make it start from a different number, e.g. 100? thx
    • Birger_H
    • 6 yrs ago
    • Reported - view
    This is not possible. The Id is a unique automatic number created when a new record is created. This number can not be changed.

    Birger - Ninox Support
    • Andrea
    • 6 yrs ago
    • Reported - view
    ...so how can I create a progressive counter number an order? THX
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Have a look at the "Invoices" template. There is a automatic progresssive order number there.

    Birger - Ninox Support
    • donbennettgslc
    • 6 yrs ago
    • Reported - view
    I have a database on my computer. I'd like to use it from iCloud. When I duplicate the database one of my calculations (a running balance) outputs the wrong amount for the 2nd and 3rd records. The rest of the records use the correct calculation but are wrong due to the beginning balances being off. I've tried deleting the calculation field and redoing it, but it's still off. Any help would be appreciated.

    Thank you,
    Don
    • Birger_H
    • 6 yrs ago
    • Reported - view
    Please send the database to me ( support@ninoxbd.de ) and I will have a loook.

    Birger - Ninox Support

Content aside

  • 6 yrs agoLast active
  • 62Replies
  • 21261Views