RoSoft_Steven's Profile | Ninox community

Badges

Latest Posts

Re: Massive update refused
Alain, You better make a button or use the console for this. Afterwards you can delete the button again. Formula should be something like this: --- for i in select Yourtable do i.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Problem with loop
I think, r.(Statut := r.2) should be: r.(Statut := 2) also if reply = "Oui l'acte a eu lieu" I think you need the whole text of that "Oui" button. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Start Page
The databaselabel menu can you find when you hover or click on the little V that appear on the right top of the icon. See the red arrow in the picture. Then the menu appear like in the picture below.…
- 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?
This might do it: --- let me := this let i := (select 'Section 1 Items' where 'Provisional Cost' = False and Id = me); sum(i.'Item Total (net)') --- 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?
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:…
- 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:…
- 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.
- 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.
- 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 :…
- 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?…
- 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.…
- 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.
- 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…
- 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.
- 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…
- 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?
- 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...
- 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.…
- 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.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Clearing Multiple Choise selections dynamicaly
Does this work : multiplechoice =: 0
- 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.
- 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
- 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
- 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.
- 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.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 48 49 50 51 52 66

Welcome to the Ninox community

RoSoft_Steven

Re: Massive update refused

Re: Problem with loop

Re: Start Page

Re: How do amend a basic sum function not add a sub-table field based on another field?

Re: How do amend a basic sum function not add a sub-table field based on another field?

Re: I would like to create a sum formula based on yes/no fields...

Re: How do amend a basic sum function not add a sub-table field based on another field?

Re: Make a function writable

Re: I would like to create a sum formula based on yes/no fields...

Re: I would like to create a sum formula based on yes/no fields...

Re: I would like to create a sum formula based on yes/no fields...

Re: I would like to create a sum formula based on yes/no fields...

Re: Moving DB from mac desktop to ninox cloud acct

Re: Data Model Tab/Page is Blank? (Beta)

Re: Could someone explain to me please how to use the Trigger after open?

Re: Could someone explain to me please how to use the Trigger after open?

Re: Could someone explain to me please how to use the Trigger after open?

Re: Could someone explain to me please how to use the Trigger after open?

Re: Alert with a Yes or No option?

Re: Clearing Multiple Choise selections dynamicaly

Re: Email address not verified??

Re: Behaviour of radio buttons

Re: must you buy a subscription

Re: must you buy a subscription

Re: How to display the last photo of the sub-table on F (X)

Overview