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
Plugins
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
1634
posts
234
likes received
5
followers
Badges
Latest Posts
Re: How do amend a basic sum function not add a sub-table field based on another field?
Maybe this is Better: --- let i := (select 'Section 1 Items' where 'Provisional Cost' = False); sum(i.'Item Total (net)') --- ps: can you try if this works also:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I would like to create a sum formula based on yes/no fields...
Do you have a cloud subscription? This is needed for sending emails within Ninox. And the line Printlayout := p Should be let Printlayout := p And also i think the line in your code : attachments:…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How do amend a basic sum function not add a sub-table field based on another field?
Try: sum(select 'Section 1 Items'.'Item Total (net)' where 'Provisional Cost' = "False") Or (without the ") sum(select 'Section 1 Items'.'Item Total (net)' where 'Provisional Cost' = False) Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Make a function writable
Supose you have a yes/no field checkbox 'client' and a numberfield 'price'. The formula in the formula field could be: if client then price else price*1,22 end Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I would like to create a sum formula based on yes/no fields...
Maybe this code will help a little: let s2 := if 'Show S2' then "1" else "0" end;let s3 := if 'Show S3' then "1" else "0" end;let s4 := if 'Show S4' then "1" else "0" end;let x := s2 + s3 + s4;let p :…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I would like to create a sum formula based on yes/no fields...
In fact, I already made an example in the past with a staging table (print que): https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/print-ordered-5e3575c8f47d0276c4016be0?…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I would like to create a sum formula based on yes/no fields...
Can you be more specific and show what the tables look like in the different tabs. I think you can solve this by creating an extra staging table and use this one to print out.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: I would like to create a sum formula based on yes/no fields...
Terry, Maybe this can help? 'Section 1 NET Total:' + if 'Show S2' then'Section 2 NET Total:' + if 'Show S3' then'Section 3 NET Total:' + if 'Show S4' then'Section 4 NET Total:'endendend Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Moving DB from mac desktop to ninox cloud acct
If you use the app (mac or ipad) you can work on both (icloud/cloud) offline and sync later. Icloud databases are synced with icloud (appleId) and cloud are synced with Ninox account and also…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Data Model Tab/Page is Blank? (Beta)
Yes, in the Beta version I also have no data model. Guess it will be fixed in the final version.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
You can see this as if you are working in the root of the database, there are no fields available because no tables have been addressed. You can do this by first choosing a table with the select…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
You mean there are no fields on the left side? That is normal ( there are no tables loaded), you can go in the editor and type your code...
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
It's the same as the trigger after open of a table only this one fires on opening the Database. An use example is to open a record or table fullscreen. Here's an example: https://ninox.…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Alert with a Yes or No option?
You can use a dialog for that: see here https://ninox.com/en/blog/ninox-release-2-4 Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Clearing Multiple Choise selections dynamicaly
Does this work : multiplechoice =: 0
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Email address not verified??
🤔 Note: In order to get there, use https://user.ninox.com to go to your account.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Behaviour of radio buttons
Multiple Choice means multiple selections possible. What you need is a choice field. Steven
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: must you buy a subscription
And this ? : https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/canceling-subscription-5ad8fdcf9604777a78f8d171
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: must you buy a subscription
I think you need to logout in order to dismiss the screen above.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: How to display the last photo of the sub-table on F (X)
Could this help?: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/displaying-multiple-image-attachments-from-multiple-records-5de20b2ee2f9823d52881b1f?page=2 Steven.
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Styled number field maintaining it numerical?
Better use a second field for that, and let that remain a number. Like a phantom field or duplicate as you prefer. you can hide this field if you want and only use the styled field visible on the…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: "Feld nur anzeigen, wenn.." Abhängigkeit
Wenn Ihr Multiple-Choice-Feld (Status) aus 2 Werten besteht, können Sie den folgenden Wert verwenden: if string(Status) = 3 then true end Hier finden Sie weitere Informationen über die…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Multiple Choice items on print invoice
Since a 4 option multiple choice field can give 16 states it will be difficult to extract which options are selected. You can use string('Multiple Choice') to determine which state of the 16 states…
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
Re: Copy a discount from the Costumer sheet subtable to Ordered Product subtable
first(Orders.Customer.'Customer sheet'.Discount) not working?
RoSoft_Steven
Ninox partner
RoSoft_Steven.1
6 yrs ago
Get help
Reported - view
1
48
49
50
51
52
66
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
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
