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
  • Comic, Wordpress cuts my formula
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    Almost, I had to do it like this

    'Color Box' := if Year >= 2000 and Year = 2006 and Year <= 2010 then
    "rgb(255,127,127)"
    else
    "White"
    Of course the White default was just a preference.
    How many times can use "else"?

    Regards
    Jon
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    Lol Opps, yeah comic ... To funny
    I meant like this

    'Color Box' := if Year >= 2000 and Year = 2006 and Year <= 2010 then
    "rgb(255,127,127)"
    else
    "White"
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    That's not the way I have it and it's not what I am pasting into the window Lol
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    First line is
    'Color Box' := if Year >= 2000 and Year <= 2005 then
    "rgb(0,63,255)
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    Second line is
    else
    if Year >= 2006 and Year <= 2010 then
    "rgb(255,127,127)"
    Like
    • jonfusa
    • jonfusa
    • 5 yrs ago
    • Reported - view
    3rd line is

    else
    "White"

    I have no idea why it keeps adding the "and year = 2006" when I attempt to paste the entire formula.
    Lol that's to funny
    Like
  • Hello,

    I am trying to determine the number of unique courses a teacher has from a table that contains all assigned courses. I am able to get it down to list of the teachers and a concatenated list of their courses.

    Screenshot 1

    Screenshot 2

    I am having trouble grouping the values in the concatenated string. I imagine it is a simple line of code, but I cannot seem to find the solution. In the end I would like the # of unique course codes to show. For example in record #1 it would have a 3 in the formula category.
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    Answered by direct mail.

    Cheers
    Birger - Ninox Support
    Like
  • Hello,

    I appreciate your help on this matter. However, I did not receive an email. I checked my junk mail and other folders. I also did a search with no success. Will you please resend the email if I missed it?

    Thanks,

    Dean
    Like
    • Min Oo
    • Min_Oo
    • 5 yrs ago
    • Reported - view
    Hi, Alex,

    I have a number field "Age".
    I want to make a color box to know that if the age is less than equal 5, red and if >5, blue.
    How should I proceed?

    Thanks,
    Min Oo
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    Hello,
    two ways you can achieve this:
    - Use a Choice field for the age. Choice field options can have a distinct color.
    - Create a formula field. Give this formula:
    –––
    if 'Age' >5 then color("blue") else color("red")
    –––

    Birger - Ninox Support
    Like
    • Min Oo
    • Min_Oo
    • 5 yrs ago
    • Reported - view
    Thanks, Birger.
    The second one is suitable for my db.
    Many of my friends are now trying to use Ninox as I told them that Ninox Support team is always ready for good advices and suggestions.
    Like
    • kustra
    • kustra
    • 4 yrs ago
    • Reported - view
    Hello - regarding the 'display field, only if' option: using the visual function editor, I don't seem to be able to display a field based on a value in a drop down field. Specifically, in a contacts table, I have a multiple choice field 'Type' as a combobox. One of the values is 'company contact'. Only if 'company contact' is selected would a company field (which is referenced to a 'companies' table') be displayed. However in the 'fields' section of the function editor I can only insert 'type' and not one of the choice values that field contains.
    Is there a workaround, or do I need to create a formula with text only?
    Thanks, Dean
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Try to use the "text" mode and give this formula:
    –––
    text('Type') = "company contact"
    –––


    Birger - Ninox Support
    Like
    • kustra
    • kustra
    • 4 yrs ago
    • Reported - view
    Thank you very much. For some reason this is causing the 'company' field to disappear completely, even when 'company contact' is selected as a value. I.e. it is not visible at all, whatever the Type value.
    Like
    • alban73
    • alban73
    • 4 yrs ago
    • Reported - view
    Hello, since the last version published (2.3) on iPhone , it is not possible anymore to update or create a new formula field . Message is «  that formula cannot update data ». Even if I try to edit any existing formula field and change nothing, when I select Ok, the error message raise. Regards.
    Like
  • Hi Alban, we'll publish a fix for this asap.
    Best
    Frank
    Like
  • Hi

    I have created a Customer database, I want Ninox to remember the customers name so I don't duplicate any records, how do I do this?
    What formula do I use in the EG: Dogs Name field

    Thanks

    James
    Like
  • To identify if a record has duplicate content use a formula field.

    let Z := Text;
    cnt((select Table_Name where Text = Z).Text)
    Like
  • Sorry I still do not understand, where do I put the formula you posted.

    What I need when I enter a new customer record is for the database to let me know if a record with that name already exists, the field I need this to work on is titled Dogs Name, is it set at the moment as a text field

    Thanks
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Here is a small example database:


    Birger - Ninox Support
    Like
  • Hi Birger, sorry I still do not understand how to do this, If I sent you the data base archive could you setup this for us?

    I would be very graftul

    Regards

    James
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Send it to me: support@ninoxdb.de - I'll what I can do :-)

    Birger - Ninox Support
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    Hi, I've a field combobox called 'Status Fattura' with five different choices: Da emettere, Emessa, Inviata, Pagata, Scaduta.
    I would like to automatically change a value of the combobox 'Status Fattura' with the following function inserted in a formula field:

    if today() > 'Data scadenza fattura' and 'Status fattura' != "Pagata" then 'Status Fattura' = "Scaduta" end

    The field 'Data scadenza fattura' is a Date field.

    But so doesn't work, the function doesn't change the value in "Scaduta" inside the combobox 'Status Fattura'.
    Why?

    Thx a lot.
    Like
Like Follow
  • 4 yrs agoLast active
  • 62Replies
  • 20746Views