Skip to main content
Forum
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
Plugin apps
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
RoSoft_Steven
RoSoft_Steven.1
Ninox partner
Belgium
www.rosoft.be
Follow
Joined
Sun Sep 30 17:18:00 UTC 2018
1621
posts
226
likes received
5
followers
Badges
Latest Posts
Re: Search Dashboard Formula Help Please.
And a ) also 😉
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Search Dashboard Formula Help Please.
I've hit the 'Post' button to fast.... text('Item Types') extracts the text from the choice field. Iv'e added lower because if you missed a capital letter there would be less mistakes. Best, Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Search Dashboard Formula Help Please.
Hi, let search := lower('Search Item Type');select Assets where lower(text('Item Types)) = search Should do the trick....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to use ‘modified on’ to display the data modified by the global today?
date(_md) gives the modified date time(_md) gives the modified time I don't know if there's an global modification-tracking of the entire database. But in the history,…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Display field only, if: either of two other fields has no data?
Yes, this forum needs an "Edit" mode to correct posted messages after we hit the 'post' button, wouldn't you think?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
1
Get help
Reported - view
Re: Display field only, if: either of two other fields has no data?
@Michael No, the field in my cace (AND) is only visable if both are emty, so if one of them is not, it will hide. Tried it with OR and doesn't work....(reverse thinking) And I think that is what Mr.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Display field only, if: either of two other fields has no data?
length(text(Phone)) < 1 and length(text(Email)) < 1 Does the trick....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Display field only, if: either of two other fields has no data?
I tried it also, something strange is going on, i don't know eighter where the error is. Anyone??? In the meantime, I'll also take a look at it when i have more time....
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to compare dates in Ninox?
You need a formula field with this: if 'Expiration Date' > today() thenstyled("Expired", "red", "warn")end
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Display field only, if: either of two other fields has no data?
The answer is already in your question : Display field only, if: 'Email 1' = null or 'Phone 1' = null
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How do I get this space field to the left of the image field?
Unfortunately a image field always align to the left. There's no other way to align it differently except if you use a formula field to pick an image from for example a file attachement.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How do you make comments in the Ninox code ?
https://ninoxdb.de/en/forum/ideas-and-suggestions-5abb9f4f45eda7ea1e75ed02/can-add-comment-to-the-ninox-query-language-5cec087016b0047abdbc101d
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Can icons be made condition on a choice field?
In a formula field(with the function format()) or icon field you can only have one build-in icon. But You could try using unicode (📎 - 🔗 - ✏ - ...)characters instead of the build-in icons.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Button action to switch from one table form to another table form?
From the blog: https://ninoxdb.de/en/blog/release-25 > The command openFullscreen(record) will pop up a screen-filling form: openFullscreen(this) or from another table :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: About Ninox searching, indexing, search speed and file size
"Index" is not recommended for normal use but in some cases it is, Birger said we normally don't have to activate this. I believe this is also still an experimental option (forgive me developers if…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to setup a global relation?
You can use a table with those records. In another table you can use record(Table,recordId).field to point to that value.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I want to show a field only if a particular item in a multiple choice field is selected. How do I do this?
Use: text(multiplechoice) = "textyouwanttocheck"
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Is is possible to get the actual day from a date?
format(date,"dddd") see chapter Date Functions here : https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to make a smaller save size with an archived database?
I think the above screen only applies to the IOS stand alone version for Mac. You can however make a backup of the entire database by clicking next to the database-icon (on the top-right of it).…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Printing a document
No experience with mac computers (I use windows,maybe a search on the web can help you) and yes, by my knowing,PDF is the only way to print reports.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Printing a document
Maybe because Pages is selected as default to open PDF files, can you chose another pdf reader on your mac?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Why does Ninox 'remember' deleted Ids?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Why does Ninox 'remember' deleted Ids?
In some versions (stand alone with icloud sync)there's an reorganize option in the menu next to the database-icon. maybe this will help with the "out of sequence" Id's.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Export selection of data
If you look in the template database invoices in the customers table, there you have an example in the view top clients where only the top clients are displayed.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Learn and share
Reported - view
Re: Why does Ninox 'remember' deleted Ids?
It has something to do with sync possibilities of Ninox, when you delete records on one device, the same id still exists on another device. Now when you create another record with the same id you've…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
1
57
58
59
60
61
65
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics