Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Lars
Lars
0711
56
13
0
Joined: Wed Mar 09 18:31:43 UTC 2022
Follow
My Posts
Latest Posts
Re: Formula Problem
Hi Rafael, it would help to know what values Schedule_V can have. But anyway, I think the numbers for comparison are not correct: The first "if" matches for Schedule_V smaller than 1 - that's maybe…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: function between two numbers
@Cirugia Toracica what about the following: "-- these are the results from highest to lowest --" let results := [3, 2, 1]; "-- these are the upper boundaries for any result --" let boundaries := [10,…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
Hello Bruno, I'm not sure what your question is. Is it "What do I have to do, to create follow-up actions?" ? It would help to see your Sales Table and to now how you realise a sale.…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
@Admin , ... I always get the direction wrong
But this might explain that you only can have monday meetings after 10:00. Try to enter a date on Sunday evening and check if it appears on Monday…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
I suppose it's an issue with local and server time. What timezone are you in? Is it by any chance UTC-10?
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: How can i get totals from a job type?
@Edward Look at your last image. What you entered is ('Total:' - 'Permit Fee:' - 'Help Payout:', "$ #.00") What you should enter is format('Total:' - 'Permit Fee:' - 'Help Payout:', "$ #.…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: How can i get totals from a job type?
@Edward you forgot the "format"-command.
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: How can i get totals from a job type?
@Edward I think you're in the wrong place to change the line. Replace your Formula (second field) where you now calculate the result. This gives you the $ in the display and still keeps real numbers…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: How can i get totals from a job type?
@Edward you're right, if it is not a real field of a table, you can't format the number by menu. Instead use the format function: format('Total:' - 'Permit Fee:' - 'Help Payout:', "$ #.00")
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: 2 questions about views
Actually you can directly write into a table. Double-click on any field and it gets into edit mode - at least in the cloud version. You can even move around with the cursor keys.…
Lars
Lars
2 yrs ago
1
Get help
Reported - view
Re: How can i get totals from a job type?
@Edward There's an option in the field configuration menu - I was wrong about the menu of the column. In the field configuration menu there's the "Number format" and by using e.g.…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: How can i get totals from a job type?
Edward, first of all, you should convert the total to a number. It doesn't make sense to keep numbers as text. If you like the $ sign, just add it in the formatting menu of the column.…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Lien d'une vue sur écran d'accueil i phone
C'est interessant ... je l'ai essayé et j'arrive a créer un lien à l'écran d'accueil. Mais le site s'ouvre, me demande de mon login et mot de passe, et je n'ai pas de clavier pour saisir quelque…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: contact with many companies
You need a model like this (it's German and a different topic, but the same method). I have houses and facility managers. Every facility manager can manage several houses,…
Lars
Lars
2 yrs ago
1
Get help
Reported - view
Re: How do i add up totals
@Edward Regarding the items in the calendar. It is important, that you store all dates in fields of type "Date". For those, there's a configuration item,…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Choose more than one?
@RoSoft_Steven Rooryck Thanks for the hint - I checked that and didn't find anything in the configuration of the field. I guess you can manually (script) limit the number,…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Choose more than one?
As Gianluca said, there are multiple choice fields. But be careful, limiting the number of selections that can be made is very difficult. So it's either 1 or as many as possible.
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca "first" changes a lot. The select command always returns an array of records. In your case, this array always has only one single record. But it still remains an array.…
Lars
Lars
2 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca It's all fine
However, you're one step ahead of me, when it comes to exporting ... I can't export the database I modified - don't know how ... So I'll copy everything into this answer.…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca it's a bit difficult if I don't know have enough knowledge about your structure and the names of your tables, but I try. First of all, you call the function already with the result of the…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca the main message is, that you (in my opinion) can't pass the dynamic choice field. That means, you have to pass the selection of the dynamic choice.…
Lars
Lars
2 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
Hi Gianluca, I'm not sure if you can pass a dynamic choice as a function parameter, because dynamic choices refer to other tables, so in the best case,…
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Dimensioni campo formula
@Antonello Stabile 71 : Do I understand correctly? You want to increase the on-screen size of a field dynamically, based on some other input? I don't know if that is possible at all ...
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Is it possible to colour the labels, as my picture show? And change back the way the colour in fields was before?
You should probably show your picture ...
Lars
Lars
2 yrs ago
Get help
Reported - view
Re: Switching to next year
The formula update the datefield is if today() > datefield then datefield := date(year(today())+1, month(datefield), day(datefield)) end;
Lars
Lars
2 yrs ago
1
Get help
Reported - view
1
2
3
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics