RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Script to set reference field to empty
With 0 (zero) i guess?
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Global script definitions
Is this what you're looking for? https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-i-set-and-use-global-variables-5c8d389b4a46f37365e396a9 Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to manage two-way multiple table references?
Have you already looked at the Invoice template? I think this could be comparable with your case, where 'plots' are invoices and 'inputs' are the articles. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
On my computer now. Did try this: let curRec := Estimation.Id;let me := first(select Estimation where Id = curRec);popupRecord(record(Estimation,me)) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
I see, it's because the relation is 1:N (more estimates are possible/invoice) maybe this will work: let curRec:= this;let me := first(select Estimation where Id = curRec);…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula Button to open a specific record
Try this: popupRecord(record('Estimation',Estimate.Id)) Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Disable the create record on the left
I think not possible. Only both buttons with User management, identities and rights (Cloud version)
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: How to pick up single value from related table
@dyrck, Is this thread similar to your situation? : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/formula-for-a-button-5e2c61c34e9f3771e468dd3e?…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Make colour of text in report change dependant on data in field
Maybe like this: Below the link to this example: https://www.dropbox.com/s/3utfz27wcw52flv/Colors.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Create a button to open directly the pdf
Yes, printRecord(recordId, layoutName) - Creates a PDF from the given record and print layout name. e.g. printRecord(this,"Invoice") Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for a Button
Hi, you can use as many commands you like, just put a ; at the end of the line. eg. --- 'Payment term' := Client.'Payment term'; VATNo := Client.VATNo; 'payment method' := Client.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Creating a random serial number / reference number in inventory
An if you are using a cloud subscription, you could ask support@ninoxdb.de to add you to the Webinar EN 2020 team where you can find a lot of usefull examples.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Creating a random serial number / reference number in inventory
Hi, Here's a reference of scripting: https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language you could also have look at (there's a free membership also): https://www.nioxus.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Creating a random serial number / reference number in inventory
Try this: if not Reference thenlet y := format(Date,"YY");let m := format(Date,"MM");let d := format(Date,"DD");let c := cnt(select Articles where year(Date) = y and month(Date) = m);Reference :…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for a Button
You can use a 'trigger after update' when you pick your client in your invoice table. (The field that links to your client) So the formula in the field 'trigger after update' would be :…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.
Not that i'm aware of.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: send e-mail problem
Are you aware it's only possible to send email from within ninox if you have cloud account? And the 'send from' has to be your ninox-account team email. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.
Thank you Dean !
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
Re: How to assign a value to a choice popup field?
Oops, there should be an edit option in this forum. Not Tablefc but Table
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Learn and share
- Reported - view
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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- 1
- Learn and share
- Reported - view
Re: Database icon
You're welcome. And thanks for the images.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 50 51 52 53 54 65

Welcome to the Ninox community

RoSoft_Steven

Re: Script to set reference field to empty

Re: Global script definitions

Re: How to manage two-way multiple table references?

Re: Formula Button to open a specific record

Re: Formula Button to open a specific record

Re: Formula Button to open a specific record

Re: Disable the create record on the left

Re: How to pick up single value from related table

Re: Make colour of text in report change dependant on data in field

Re: Create a button to open directly the pdf

Re: Formula for a Button

Re: Creating a random serial number / reference number in inventory

Re: Creating a random serial number / reference number in inventory

Re: Creating a random serial number / reference number in inventory

Re: Formula for a Button

Re: Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.

Re: send e-mail problem

Re: Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.

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

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

Overview