RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1589
211
5

Joined: Sun Sep 30 17:18:00 UTC 2018

https://www.rosoft.be

My Posts

Latest Posts

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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Bug in webversion?
It does work in the google chrome browser however....
- Ninox partner
- RoSoft_Steven.1
- 5 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
- 5 yrs ago
- 4replies
- 884
- 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Oops formula 2 should be : " " + name
- Ninox partner
- RoSoft_Steven.1
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- 25replies
- 5244
- 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
- 5 yrs ago
- Get help
- Reported - view
Re: Search Dashboard Formula Help Please.
And a ) also
- Ninox partner
- RoSoft_Steven.1
- 5 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
- Ninox partner
- RoSoft_Steven.1
- 5 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....
- Ninox partner
- RoSoft_Steven.1
- 5 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,…
- Ninox partner
- RoSoft_Steven.1
- 5 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?
- Ninox partner
- RoSoft_Steven.1
- 5 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.…
- Ninox partner
- RoSoft_Steven.1
- 5 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....
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 55 56 57 58 59 64

Welcome to the Ninox community

RoSoft_Steven

My Posts

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

Re: Search Dashboard Formula Help Please.

Re: Search Dashboard Formula Help Please.

Re: Search Dashboard Formula Help Please.

Re: How to use ‘modified on’ to display the data modified by the global today?

Re: Display field only, if: either of two other fields has no data?

Re: Display field only, if: either of two other fields has no data?

Re: Display field only, if: either of two other fields has no data?

Overview