Text / Date Functions

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

Here is a small example how this could be done. Enjoy:


Birger - Ninox Support

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?

leo.semik@gmail.com

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