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
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
Like Follow
62replies
-
Hello. I have a question about assigning behaviour to a button. I need a value in a certain field to increase as I press the button. So let's say it starts from zero and then clicking the button that value goes "1", then pressing it again it goes "2" and so on.
How can I arrange the formula?
Thanks for your help.
Great app by the way!
- Gianluca -
My only reference is using Filemaker. When I create a "formula" field in Ninox I can only return numbers. FM allowed the choice of creating a calculation in either a Number or Text format.
Basically, I am trying to generate a string of text, based on dates/numbers using the creation date of the file. Nov 2, 2016 would be output as 2016_1102_01 and ascending numbers ...02...03...4 The numbering sequence (based on the date) starts over each day, plus an ascending number at the end.
Easy stuff with FM, but I am trying to understand the syntax used to create calculations that result in a string of text characters (resulting from a alpha-numerical calculation) with Ninox. -
Hello,
with formulas you can also return text.
To create a subsequent number for invoices for example, the best method id to use a trigger on table level "on create". Each time new record is created the trigger will be executed and insert the invoice number into a text field for example.
The following example creates an invoice number with year month and day. Invoice are counted upwards for each day.
let y := year(Date);
let m := month(Date);
let d := day(Date);
let c := cnt(select Invoice_Table where year(Date) = y and month(Date) = m);
InvoiceNo := y + format(m, "00") + format(d, "00") + format(c, "00")
Note: Date is the name of the date field; Invoice_Table is the name of the table with the invoices; InvoiceNo is the name of the text field with the invoice number.
If there are question you can also drop a line to support@ninoxdb.de
Best regards, Alex -
Hi Frank,
Can we build on Gsechi's post as follows.
Suppose we want to make 10 buttons number 0-9 ( like a touch tone phone )
Getting the number 0-9 in field is pretty straight forward....
MyField := the button number goes here
Works great for numbers 0-9, but how do I get the number 10-99 or even 100-999 using the same 10 buttons?
The app & support is the best !
Regards
Jon -
Hi Jon,
Create ten buttons from 1 - 10. On each button you put a trigger.
for Button 1:MyField:= MyField +1
for Button 2:MyField:= MyField +2
and so on. This works if MyField is a text field.
If you have questions you can also drop a line to support@ninoxdb.de
Best regards, Alex -
HELP - I have 11 number fields in the same record. After each field receives an entry I wish to calculated field to work out the 1st highest entry and the 2nd highest entry as each entry is made. In excel there is a function called LARGE. for example Large(A1:A11,1) returns the largest number in the cells A1 to A11 inclusive. Large(A1:A11,2) returns the 2nd largest number in the same range. I wish to replicate this in Ninox......
-
So, I have a field "SerialNumber" and a field "Year" The 4th digit of the serial number is a letter, and the letter signifies the year.
Example: if the serial number is 24YG3A06498E, the 4th digit from the left is G so this tells us the year is 2005.Serial number 24YH6A4365w the H tells us the year is 2006.
Is there a solution which will populate the " year " field automatically with the correct year based on the 4th digit of the number placed into the "SerialNumber" field?
Regards
Jon -
Hi Leo,
Kudos to you,the team,and Ninox.Your solution to the problem now works perfectly.I have made a not about the error behavior with the quotation marks when using Mac/iPad.After 20 years of PC's, Windoz and MS Access, we switched to Mac and never looked back.
Thanks again for all your help, database is growing, 3500 records still working like a charm.
Regards
Jon -
So, I am attempting to use a color box and set the color based on a calculation.
Example: if field "year" is between 200 and 2005 I want the color box to be red,if year is between 2006 and 2010 I'd like the color box to be blue, ect etc.
How would I achieve this?
App is still working great with over 1000 records and climbing.
Thanks for any help or examples
Regards
Jon