0
Text / Date Functions
I need to have a field that calculates 342 days added on to ‘breeding’ date entered in a table -
So if someone enters 1/1/2016 for a breeding date
I need the foaling date to show: 12/8/2016 (342 days later)
is there something like (Breeding_Date)+342(days)
So if someone enters 1/1/2016 for a breeding date
I need the foaling date to show: 12/8/2016 (342 days later)
is there something like (Breeding_Date)+342(days)
71 replies
-
Hi Martin,
try this:
https://www.dropbox.com/s/d4kgfhvgfpaai1k/All_Day_Appointments.ninox?dl=0
regards
Leo -
Now I understand :-)
I fixed the display in the calendar but you asked about the field view in the record. I'm afraid I can't help you with that. Every Appointment has a time and you can't have the field not show the time.
Birger - Ninox Support -
Thanks Leo, that seems to work okay. Thats a great help...
There appears an error, in the
Trigger After Update (D := ((number(F)+"/")+number((G-F)))
Invalid formula: Error: Field not found: "D" a line 1, column 5
should I ignore this? -
Hello,
I'm currently on a 30-day trial for the cloud service. It looks like Ninox can provide a lot of the functionality I'm looking for for my business. I want to use the multi-line text field to enter notes/contact history for a contact/company, but it would be great if there were a way for the current date to be entered automatically at the beginning of an entry so that I know when I wrote it, or when I sent an email to the contact. Is this possible?
Regards,
Dean -
Dear Birger,
Many thanks for your very speedy reply - I'll take a look about incorporating this function into my trial database.
Thanks again.
D. -
The function weekday(date) is supposed to return 0=Sunday, but for me it its returning 0=Monday. (System preferences is set to Sunday as the first day pf the week).
-
Ninox has not native preferred first day of the week. It will look at the browser and/or system preferences to determine the first day of the week.
Birger - Ninox Support -
Hi, I have a choice field called "Callback in" with the options 3, 6, 9 and 12 (being a number of months).
I want to calculate a date which is x number of months from a certain date ("Last contacted"), where x is the choice selected.
I tried "'Last contacted' +( 30 * number('Callback in'))" as the simplest solution but it doesn't work - it just adds 1, 2, 3 or 4 months to the date, not 3, 6, 9 or 12.
Can you help please? Alternatively is there a way of calculating it using calendar months rather than an average of 30 days per month?
Thank you! -
Hello Jeni,
either
'Last contacted' + (30 * number (text ('Callback in'))
or with calendar months
date (year ('Last contacted'), month ('Last contacted') + number (text ('Callback in')), day ('Last contacted'))
Leo -
Thank you - that's working now, I knew it would be something simple.
However, it only works once and then the fields "lock" unless I come out of the record and go back in. Is that correct? I was hoping I could select the different options without going in and out of the record?
Thanks -
I don't understand that. Which data fields do you mean?
-
Hi Leo - now I have put the formula in place, I can't select anything from "Callback in" unless I reload the database. I can then select an option and it updates the date.
However, if I then try to change "Callback in" to a different choice, it won't let me. I have to reload the database, go back to the record and then it works.
Does that make sense? -
I do not understand. If you have three fields:
1. 'last contacted' (date)
2. 'callback in' (choice)
3. 'Next Contact' (f (x) with your formula)
Then everything should work. -
Hi Leo - can I send you the database so you can see what I mean?
-
Hello!
is possible to show date without year?
eg.
07 mar
thanks and regards.
stefo -
That would be:
–––
format( 'Date field', "dd mmm" )
–––
Birger - Ninox Support -
Hi, I'm a current Tapforms user investigating wether Ninox could be a useful replacement...
I need a calculated field to show the remaining years & months between "today" and a date in the future (other field).
I can't find in your user manual wether Ninox can actually provide such a type of format as the result of a calculation? Like for example: "4 years, 3 months".
Would that be possible and how should that be achieved?
Much appreciated.
Thierry -
Hi Thierry,
Here is a sample database. The duration is calculated in both directions (future and past)
https://www.dropbox.com/s/1fz6tdefgk0pjkn/DURATION.ninox?dl=0
regards
Leo -
Hi,
i have a "date X" field and need to calculate (in a new field) dateX minus 120 days, (with the format of the result to be also a date of course).
Could you please provide me the correct formula for this as i'm struggling...
Much appreciated,
Thierry -
Hi Thierry,
you can use a formal field:
dateX - 120
it will give out a date, as well.
Best regards, Alex -
Hi,
can I change the name of a field in bold and the size of the font?
Thx -
No. Not yet. You can set the global font size here:
Birger - Ninox Support -
Hi,
I've the function in a function field named "Check":
if 'Fattura N.' != null then
"Fatturato"
else
if 'Data ricezione' != null and 'Data invio a fornitore' != null and 'Data evasione fornitore' != null and 'Data invio a cliente' != null then
"Fatturabile"
else
"Non Fatturabile"
end
end
I would like to add an icon near text "Fatturato", "Fatturabile", "Non Fatturabile".
Is it possible?
thx a lot
Content aside
- 6 yrs agoLast active
- 71Replies
- 30131Views