Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Auto-populate one field based on another
Try number(Field1)*number(Field2) maybe that will work Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Automatic updated field with date for each time I update something
Hi, check here:…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Support nested if
Hi, Have a look here in the manual under the section 'Making decisions': https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language For examples you can also have a look at the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
To delete it in the script you can use: delete this Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
@ Wolfgang, where did you put your script? In the Trigger after update of the 'Field' is the right place. try using =2 instead of >1 in the script. this works for me in the webapp windows 10 chrome.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: CRM DB
What did you have in mind Stephen? If it's not too extensive, I'll make one for you. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Map image with location field?
Hi, have a look here:https://developers.google.com/maps/documentation/javascript/get-api-key It seems like you'll gona need a payed subscription in order to get an api key. Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How do you delete a record in a sub-table?
Go to that subrecord and use the trashcan icon to delete that record.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to get View table to show and print more than 6 lines on an invoice?
In the print layout screen, It shows indeed not all the records, once you print (make PDF) all the records will be printed.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formular
Fur multiple field searches, you can use the built-in searchfield. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Help
I think it has something to do wih your Sector fields, are you using thousand seperator instead of decimal?
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Help
Are your Sector fields number-fields? I have this:
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Help
Something like this: --- let Ts := 'Sector 1' + 'Sector 2' + 'Sector 3';let m := floor(Ts / 60); let s := Ts - m * 60;format(m, "00") + "m" + format(s, "00,000") + "s" --- Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Help
Hi, Suppose you have a numberfield 'TotalSeconds' that hold the ammount of seconds, then you can put this in a formula field: let h := floor(TotalSeconds / 3600);let m :…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formular
Hi, I've made a little example database: https://www.dropbox.com/s/mer0ud09tn8ddxr/Search.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Concat Formula
Thank you for your valued comment, Sean, we're learning every day.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Concat Formula
So in other words, join('Customer Notes'.'Contact Date and Type'," ") should do the trick? S Moore, can you try this and provide feedback please?
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
Text
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Poll: are you using the visual or the text editor in formula editing?

Survey for the Ninox developpers team. Please answer with visual or text.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- 14replies
- 2410
- Learn and share
Re: Concat Formula
Try here: join(split(concat('Customer Notes'.'Contact Date and Type'),","),"• ")
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Concat Formula
Hi, can you try this: --- let q := concat('Customer Notes'.'Contact Date and Type'); join(split (q,",")," ") --- or in one line (not sure it will work): join(split(concat('Customer Notes'.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Concat Formula
Hi, from the manual: join(array,"separator") - Returns a string result with each element separated by a separator of your choice. That can also be a line break and/or a string. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: function valid for one time
Best way to do this is with a button. Not with a formula field. Let's say you have 3 numeric fields A,B and C. The button formula would be for example C:= A * B So only when you click on the button,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Reviewing duplicates in one field
You can put this in the 'Trigger after update' of your Identification field : let p := Identification;if cnt(select laye where Identification = p) = 2 thenIdentification := null;…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Create subrecord automaticaly
Here's an example. https://www.dropbox.com/s/zzcnjjxaongb8rb/Appointments.ninox?dl=0 Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 53 54 55 56 57 65

Back to top

Overview

View all topics