Nick's Profile | Ninox Community

Badges

Latest Posts

Re: Automatic progressive number WHEN IMPORTING - Urgent help!
Yo can update the ID Numbers after the import with something like this (button or Console) let myNum := 1;for i in (select YourTable) order by FieldName doi.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: 2 views different fields
Yes it is
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Can I write of annotate or write comments in my functions?
Read here https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-i-place-a-comment-in-a-script-5bfd8ea466009502a4508a5a
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Help with "do as server" script
Well, without the "do as server" step, takes about 40 seconds to create 20 records to a subtable (approximately 2 seconds per record). With the "do as server" step in the script,…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Help with "do as server" script
Thanks Birger!
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Display Formula as Month?
You are welcome. I know what you mean, it shows me Sunday and Monday as a weekend rather than a Saturday and in a timed field with trigger on creation for the current time,…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Display Formula as Month?
format('Beginning Date', "MMMM")
- Nick
- 5 yrs ago
- Get help
- Reported - view
Help with "do as server" script

Hi all, I have a button with code to create a number of records to a subtable... The code is: --- let reply := dialog("Confirmation!", "I will create " + '# of Payments' + " records, with Bill Data.…
- Nick
- 5 yrs ago
- 3replies
- 1554
- Get help
Re: Copy data.
To copy data to another field: --- Field4 := Field1; Field5 := Field2 ...and so on To copy data to another table: --- let f1 := Table1_Field1;let f2 := Table1_Field2;let f3 := Table1_Field3;let c :…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Calculation of running balance
Try something like this let myID := Id;let prev_d := sum((select 'Current 19/20')[Id <= myID].Debit);let prev_c := sum((select 'Current 19/20')[Id <= myID].Credit);prev_d - prev_c
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to assign a value to a choice popup field?
Assuming Popup Values are 1 = A 2 = B 3 = C 'Choose a Letter' := 1 or 'Choose a Letter' := text("A")
- Nick
- 5 yrs ago
- Learn and share
- Reported - view
Re: Create tables with autonumbering with ease.
Hi Steven, I'm looking for something automated.I work with the mac application most of the time using Command + D and I hate that you have to do the most work with the mouse ... 🤔
- Nick
- 5 yrs ago
- Learn and share
- Reported - view
Re: How can I have a formula that counts records from a table?
Something like this let p := 'Your String';cnt(select TableName where 'Your String' = p)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
Thanks Steven! Any workaround for when we duplicate records?
- Nick
- 5 yrs ago
- Learn and share
- Reported - view
Re: Duplicate information from one table to another table depending of the status selected
No problem! My model is: - Order table with subtable Order Lines - Invoice table with subtable Invoice Lines - Button "Create Invoice" with the above code in Order form - Customers and products…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Duplicate information from one table to another table depending of the status selected
Hi! I'm using this code to convert Sales Order to Invoice with a button: --- "//--------Define Order ID in variable";let myId := Id;"//--------Get customer info";let cli := Customer;let disc :…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Script to find and return duplicate records that already exist
Try this: let myV := Vendor_Name;if cnt(select YourTableName where Vendor_Name = myV) > 1 then"Duplicate"elsenullend
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
Another test (7 pages document)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
...but I didn't add any text field, just modified the Ninox default counter at the bottom right corner
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
This works for me: Page: $page of $pages
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to be linked to a choise field
In the Invoices table put something like this in Trigger after update: if Customer.'VAT Status' = 1 or Customer.'VAT Status' = 2 then'VAT Rate' := 23elseif Customer.'VAT Status' = 3 or Customer.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Sum sub table
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Sum sub table
Try this: let t := this;sum((select Milestones where Milestones = t and Type = 1).Amount)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Sum sub table
Yes it works...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Horizontal line separator in form
Create a "Head" layout element with empty title and select a bottom or top border in it's style attributes.
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 10 11 12 13 14 29

Welcome to the Ninox community

Nick

Re: Automatic progressive number WHEN IMPORTING - Urgent help!

Re: 2 views different fields

Re: Can I write of annotate or write comments in my functions?

Re: Help with "do as server" script

Re: Help with "do as server" script

Re: Display Formula as Month?

Re: Display Formula as Month?

Help with "do as server" script

Re: Copy data.

Re: Calculation of running balance

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

Re: Create tables with autonumbering with ease.

Re: How can I have a formula that counts records from a table?

Re: Create tables with autonumbering with ease.

Re: Duplicate information from one table to another table depending of the status selected

Re: Duplicate information from one table to another table depending of the status selected

Re: Script to find and return duplicate records that already exist

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: Formula to be linked to a choise field

Re: Sum sub table

Re: Sum sub table

Re: Sum sub table

Re: Horizontal line separator in form

Overview