Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Lars
Lars
0711
56
13
0
Joined: 09 Mar 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
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
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…
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.…