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
62 replies
-
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 -
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 -
-
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.
Content aside
- 6 yrs agoLast active
- 62Replies
- 21250Views