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
• 6 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
• 6 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
• 6 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
• 6 yrs ago
• Reported - view
First line is
'Color Box' := if Year >= 2000 and Year <= 2005 then
"rgb(0,63,255)
Like
• jonfusa
• jonfusa
• 6 yrs ago
• Reported - view
Second line is
else
if Year >= 2006 and Year <= 2010 then
"rgb(255,127,127)"
Like
• jonfusa
• jonfusa
• 6 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
• 5 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
• 5 yrs ago
• Reported - view
Try to use the "text" mode and give this formula:
`––– text('Type') = "company contact" –––`

Birger - Ninox Support
Like
• kustra
• kustra
• 5 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
• 5 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
• 5 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
• 5 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
• 20810Views