RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Wanting a single record instead of the array.
Try using first() in your code(code goes betweed brackets) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Change field label text depending from another field Value
You could make labels with a formula field e.g. : if language=1 then "Street" else "Rue" end Here is language a choice field with 2 options.(English and French in my example) And just name the…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create a button to send an email with a file
** (only available in Ninox Cloud/Ninox Server teams) See: https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Display multiple records in one line in formula
Does this work in your situation? : join(InventReference.VendTable.Abbreviation + " " + InventReference.Reference," ") Didn't try myself (lack of time) Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How do I do a text calculation (e.g., First Name & " " & Last Name)
Does your suffix field comes from a dropdown selection? Then you must use: text(Suffix)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Have also a look at this thread : https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Bug in webversion?
@Birger, I've demonstrate it in a past webinar, if I use firefox(v.69.0 64bits) on PC Windows 10, i have this problem, with Google Chrome on the same pc I have no problem.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Create new record in the table with a button?
You're welcome. A small correction, you can delete the first line, this is not necessary (let currRec := Id;) It's just a habit when I make longer code. 🥴
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Print view: invoice form calculations
For the slide up, see this thread : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/creating-an-address-block-from-different-fields-5cf46a93cdd5bd2503245b15?…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create new record in the table with a button?
Hi, you can use this code for your button in a table called e.g. Category (change this by the name of your table): let currRec := Id;let i := (create Category);openRecord(record(Category,i.Id))
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to show tables marked hidden ?
Are you sure you're in administration mode? (Wrench topright must be RED) In the database model you can see all the tables where you can even select that table and unselect the hidden checkbox.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Print preview vs pdf
I have the same problem with the webversion. I don’t have a problem with the Ipad version. So that’s my solution for now. Hopefully solved with the new version coming soon...
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Bug in webversion?
It does work in the google chrome browser however....
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Bug in webversion?

In the table view, it is not possible to scroll up or down or even select a row to go in to the formview of that record. I'm using firefox(latest) on windows pc and safari on my Ipad (iPadOs 13…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- 4replies
- 892
- Learn and share
Re: problem returning an ID
Did you try with first() ? first(select shipping where actuel = true).ID) Didn't try myself (lack of time), maybe a bit tweaking is needed.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Use a number in a choice field as a multiplier of a number field?
You forgot a ) after Commission.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Show Date as Year Only
Formula goes in a formula field. A date field itself cannot be changed, just the looks in the calender are changed where you've put your formula in screenshot.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Use a number in a choice field as a multiplier of a number field?
Assuming your choice field exists of numbers, we first take the text part of that choice field 'text(choicefield)' and than make it a number so we can calculate with it 'number()' see the complete…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Oops formula 2 should be : "⚠ " + name
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Styled formula background
I see, it's a strange behaviour when you use style the line break goes away. Maybe a bug? I would make 2 different formula fields and not using styled() but use a unicode icon instead for the second…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Have you tried this already? styled(yourformula,if 'Flag Account' then "red" end)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
For those who don't have an cloud account, here's the link to download it manually: https://www.dropbox.com/s/387bqz4vwt1itck/AutoNumber.ninox?dl=0 enjoy 😉
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: Automatic Numbering Issue
Have also a look at: https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4?…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Create tables with autonumbering with ease.

Since i see a lot of questions passing by on this forum about autonumbering I desided to make an template with a little different approach. Just posted it in the Webinar EN 2019 team.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- 25replies
- 5319
- Learn and share
Re: Formula to select a tab in form view
This is not yet possible at the moment. But there's already a change request for that (N°1213). If you're a member of the NINOX Beta Team, feel free to upvote that one.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 56 57 58 59 60 65

Welcome to the Ninox community

RoSoft_Steven

Re: Wanting a single record instead of the array.

Re: Change field label text depending from another field Value

Re: Create a button to send an email with a file

Re: Display multiple records in one line in formula

Re: How do I do a text calculation (e.g., First Name & " " & Last Name)

Re: Need a field formula that inserts a unique and sequential number?

Re: Bug in webversion?

Re: Create new record in the table with a button?

Re: Print view: invoice form calculations

Re: Create new record in the table with a button?

Re: How to show tables marked hidden ?

Re: Print preview vs pdf

Re: Bug in webversion?

Re: problem returning an ID

Re: Use a number in a choice field as a multiplier of a number field?

Re: Show Date as Year Only

Re: Use a number in a choice field as a multiplier of a number field?

Re: Styled formula background

Re: Styled formula background

Re: Styled formula background

Re: Create tables with autonumbering with ease.

Re: Automatic Numbering Issue

Re: Formula to select a tab in form view

Overview