RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1552
200
4

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

https://www.rosoft.be

My Posts

Latest Posts

Re: How to assign a value to a choice popup field?
Do you mean a popup dialog within a script? In this example i have a number field "Tablefc and a button with the code below.Table := dialog("Table", "Table number ?", ["1", "2", "3", "4", "5", "6",…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Create tables with autonumbering with ease.
Well, maybe it's time to buy a windows computer with touchscreen and subscribe for a cloud account. No mouse needed... just kidding hey... Honesty, i have no idea right now Nick,…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Create tables with autonumbering with ease.
Not yet, do you have an idea Nick? Maybe with a button to duplicate a record and then trigger the counter? That could work I think.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Create tables with autonumbering with ease.
1) Art No is a pefix for the number in Number field eg "Art No : 001" 2) its an addition to use one time to populate the emty fields. Once the field is populated the trigger on create field does the…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Create tables with autonumbering with ease.
Hi, The best way to do this is to make use of a temporary button and after the execution you can delete this button again. in this example i have a table called Articles where i put a field Number.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- 1
- Learn and share
- Reported - view
Re: Database icon
You're welcome. And thanks for the images.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds
funds
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds
Sorry, i think instead of Balances in line 9 it must be the name of your parent table.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Database icon
Click alittle bit on the top tight of your icon and a dropdownmenu will appear. There you chose Rename database. Now you can rename the database but also when you click on the icon change it(even the…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds
let currentRec := thislet Nyear := last(Balances.Year) + 1;let Nbeg := last(Balances.'Temp. Restricted');let Nperm := last(Balances.'Perm. Restricted');let i := (create Balances);i.(Year := Nyear);i.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
Yes, the use of := and = is reversed, switch those two....
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Reviewing duplicates in one field
let p := 'Article No';if cnt(select Article where 'Article No' = p) > 1 and 'Article No' != null then"Duplicate"elseif 'Article No' != null then "Unique" else "null" endend change 'Article No' to…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: How can I get the Id number of a record in a linked table?
Try this: let thistype :=first(select MasterListLabels['Label' = "Project"].Id); m.(Type := thistype) Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
@ Ninox Support: can you help us with that? Or anyone else...
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
I think your text field must be in the footer. Can you check that? Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.

Pictures say more than words... Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- 24replies
- 4140
- 3
- Learn and share
Re: Have a Page number on the Print document
A possible hack is to increase the hight of the page in the print layout screen and afterwards set it back to normal. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
It's normal in the print preview there are only some records/pages visible but once you create the PDF all records/pages should be visible. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
Add a text field with this:Page $page of $pages Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Sean, No problem at all, I'm not familiar with RegEx (I know you do, an I was already kinda expecting an answer from you ) so I gave an alternative solution. Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Hi, Try this for the first question in a formula field: you can always add if r>30 then alert("message") end let r := 0;let k := length(Text);for i from 0 to k doif substring(Text, i,…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Simple Log in system with date/Time registration.
Thanks Michael, This is a small part of my POS system, where a new record is indeed created with the name belonging to the entered code. This way you can see who entered the orders.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Horizontal line separator in form
Or you can use a formula field and hide the label ,with this as formula: html("<hr>") in the style chose background rgb as above. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Houw can I protect the database with a password
Or this: https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/simple-log-in-system-with-datetime-registration.-5e11d00509d132371a594f5c
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 48 49 50 51 52 63

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: How to assign a value to a choice popup field?

Re: Create tables with autonumbering with ease.

Re: Create tables with autonumbering with ease.

Re: Create tables with autonumbering with ease.

Re: Create tables with autonumbering with ease.

Re: Database icon

Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds

Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds

Re: Database icon

Re: Choice field and formula

Re: How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds

Re: Choice field and formula

Re: Reviewing duplicates in one field

Re: How can I get the Id number of a record in a linked table?

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: If a text field has > 30 '#' then show alert

Re: If a text field has > 30 '#' then show alert

Re: Simple Log in system with date/Time registration.

Re: Horizontal line separator in form

Re: Houw can I protect the database with a password

Overview