RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Icons in Choice
You can. The left circle is for the color of the choice and the second circle is for the icon. Or can use your own Icons Using UNICODE characters. Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Separate multiline text field into individual rows?
Hi, you can hide the button with a triggered yes/no field (ViewButton) whith the option required to yes and standard value to yes. This schould be added to the buttons code: ViewButton :…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Autofill Formula
Oops, not Terri but Terry. This forum defenitely needs an 'edit' button.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Autofill Formula
In your case it could be : 'Street Adress:' := record(Settings,1).'Street Adress' This is the syntax tu pull data from other tables: record(tableName, recordId).fieldName Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Autofill Formula
Hi Terri, Have a look here at this sample database where i pull numbers from a settings table. https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Separate multiline text field into individual rows?
Made this example which build records ('Text' -field contains the lines from the content) in a Subtable 'Lines' from the content of the multiline Textfield. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Html text
Wynand, Maybe this helps a little (Pictures say more than words...) Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Rounding Formula
From the manual: round(x) – Rounds a number to the nearest integer.round(x, digits) – Rounds a number with the given amount of digits.| round(1.234, 2) => 1.23| round(12345.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view

1 47 48 49 50 51 65

Welcome to the Ninox community

RoSoft_Steven

Re: Icons in Choice

Re: Separate multiline text field into individual rows?

Re: Autofill Formula

Re: Autofill Formula

Re: Autofill Formula

Re: Separate multiline text field into individual rows?

Re: Html text

Re: Rounding Formula

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?

Overview