Formulas

Comic, Wordpress cuts my formula

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

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"

That's not the way I have it and it's not what I am pasting into the window Lol

First line is
'Color Box' := if Year >= 2000 and Year <= 2005 then
"rgb(0,63,255)

Second line is
else
if Year >= 2006 and Year <= 2010 then
"rgb(255,127,127)"

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

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.

Answered by direct mail.

Cheers
Birger - Ninox Support

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

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

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

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.

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

Try to use the "text" mode and give this formula:
–––
text('Type') = "company contact"
–––

Birger - Ninox Support

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.

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.

Hi Alban, we'll publish a fix for this asap.
Best
Frank

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

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

let Z := Text;
cnt((select Table_Name where Text = Z).Text)

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

Here is a small example database:


Birger - Ninox Support

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

Send it to me: support@ninoxdb.de - I'll what I can do :-)

Birger - Ninox Support

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.