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
blackie
blackie
193
0
0
Joined: Sun Jul 01 20:40:51 UTC 2018
Follow
My Posts
Latest Posts
Re: Function result from multiple tables
Maybe try to convert to text before converting to a number??? number(text(INSTRUMENTATION.Total))
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Iphone printing
I can create PDF files for printing on the iPhone App.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: How to read/copy the file name of a picture in an image container
You can get the image name with a formula like this: let path := text(Image);substr(path, index(path, "/") + 1)
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Travel to a different time zone changes dates
It probably has something to do with dates being stored in Unix time.…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Email the contents of a record
I think you are missing ; at the end of the first line. importFile(this, printAndSaveRecord(this, "Weddings"), 'Bride, Last Name' + ".pdf");
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Some User Defined Array Functions
Shouldn't the 'if' statement in aAppend be similar to the other functions? count() is listed as a array fucntions, but ary is text. function aAppend(ary : text,newItem :…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: This is driving me crazy
If I don't have the dummy global function, the else statement is always run, so I end up with just "Test 2" at the end in the formula. If I add the dummy global function, it works and I get "Test 1,…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Date field color
You can use styled() in a formula, but not with a date field. why not just mark the feild as required?
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Hide an Icon field
maybe '1st Meeting Date' != null
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Has anyone successfully used "Global script definitions"?
I was also trying to define some global variables and arrays, so that is probably why my tests didn't work. It looks like all outside variables need to be passed to global functions in the arguments.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Has anyone successfully used "Global script definitions"?
I haven't tried much, but haven't had any luck yet.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: NINOX 2.5.0 New Features?
There is the blog post https://ninoxdb.de/en/blog/release-25
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: How do I add log-in security to a Ninox Database?
Here is an idea for a poor mans version of a PIN code protection for a DB. it is used in "Trigger after open". let passcode := "1234";let enteredCode := "";while passcode !…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: How do I add log-in security to a Ninox Database?
Wouldn’t each user on the Mac have thier own, separate DBs? If the DB is stored on iCloud, each user will need access to that iCloud account. i would like the password for the iPad version where…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Improved Array Functions
This is also a nice start of an array sorting function.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: NINOX 2.5.0
GANTT charts.... I wish there was a way to specify the color of the GANTT bars. Like if they took their color from the "Status" , or some other choice/multiple field.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: NINOX 2.5.0
2.5.0 is live https://ninoxdb.de/en/blog/release-25 createTextFile will be useful to me. I wasn't aware of it until I read the blog post. With the new function createTextFile(record, contents,…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Improved Array Functions
Nice! thanks for sharing
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: How do I add log-in security to a Ninox Database?
Users and permissions requires Ninox Cloud. You could create a trial account if you want to try it out.
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: automatic filling of fields
You could use something like the Google OCR API to pull the info from a photo. https://cloud.google.com/vision/docs/ocr
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Zip Code Populate city and state?
slowwaggon's solution is better for auto updates. I grabbed a zipcode DB from here. https://simplemaps.com/data/us-zips I imported the csv and created a new table.…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Zip Code Populate city and state?
Can't use http() in a trigger, so it would have to be a button or something. You would need an API key. Use this API to find out the city, state, latitude, longitude,…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Zip Code Populate city and state?
You could also use an API to get the city and state info. https://www.zipcodeapi.com/API
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Sending attachments via API
I think that is what it will look like from the Mac app. from the web app it will look something like this: https://dbde0005.ninoxdb.de/4x3XbZ54gX2ERXBXD/root/loadfile/Table39.…
blackie
blackie
5 yrs ago
Get help
Reported - view
Re: Sending attachments via API
Are the invoice PDF files generated by Ninox? If they are, you can get the path to the local file before it is imported into the Ninox database. Text := printAndSaveRecord(this, "layout")
blackie
blackie
5 yrs ago
Get help
Reported - view
1
2
3
4
5
8
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics