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
62replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Andrea,

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

    regards
    Leo
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    are you sure? it doesn't work
    a pop-up says: in Italian "Questa formula potrebbe non modificare i dati"..
    Like
  • 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
    Like
    • Andrea
    • Andrea
    • 4 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
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    Hi,
    where can I find the list of icons names?
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Here:
    Iconset.ninox


    Birger - Ninox Support
    Like
    • Andrea
    • Andrea
    • 4 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
    Like
    • Birger H
    • Birger_H
    • 4 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
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    ...so how can I create a progressive counter number an order? THX
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Have a look at the "Invoices" template. There is a automatic progresssive order number there.

    Birger - Ninox Support
    Like
  • 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
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Please send the database to me ( support@ninoxbd.de ) and I will have a loook.

    Birger - Ninox Support
    Like
Like Follow
  • 4 yrs agoLast active
  • 62Replies
  • 20711Views