Skip to main content

Ninox-Documentation

Nick

Nick

Greece

699
29
1

Joined: Wed Jan 01 00:00:00 UTC 2014

My Posts

Latest Posts

Re: Confirm box when new record
This code works for me, if it helps: let check := dialog("Add record", "New record will be added. Continue?", ["Yes", "No"]);if check = "Yes" then create 'YourTable' else void end Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: zipcode field removing leading zeroes
You need a 'Text' field and not numeric.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: "comments" in the code
"Define ID in variable";let myId := Id;"Get customer name";let myCust := Customer; Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Paiement status update with "due date" in another table
Hi, I don't know you setup, but in general: create a formula field named e.g. Invoice Status and type in the formula editor the code: -- if 'Payment Date' = null then "Not Paid" else "Paid" end --…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Table limit of 6 items in the print template
This is just a preview. Continue to 'Print PDF ang you'll get all records in the pdf. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Button Save Record
Try: openTable("tableName", "viewName") Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Transfert estimate record to invoice
Finally works!!!! Thank you Birger and, of course, Thierry... Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Transfert estimate record to invoice
The link is wrong (has a space character) -http:// veloroule.ch/Loop test.ninox- Download the file from here http://veloroule.ch/Loop test.ninox Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do I Exit out of 'View' 'Find in view' back to previous page showing ALL records
Two ways: Right click on the left checkmark column and select 'Show everything' and Cmd-F again and click 'Show everything' Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Transfert estimate record to invoice
+1000
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Transfert estimate record to invoice
I post the same question a few days back and I had an answer from 'support'. But I never manage to make it work. Let's unite our forces :-) Here is the post https://ninoxdb.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Calculated field
Get some ideas in this post: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/if-statement-between-dates-5b6e9b0203f12310870ad4ba?post=5b6f2b2f03f12310870ad4d7&page=1
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Help creating Invoice Numbers
You can try another approach: Create a formula field 'Count_Inv' -> "count(Invoice.Id)" in Customer table. and the trigger: let myClient := Customer.Id;'Invoice No' := myClient.Id + "-" + Customer.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Help creating Invoice Numbers
I tested the Birger's formulas and they're working fine! So, please try again and follow the steps exactly...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
The 'Right' field is a formula field with the code -> html("<p align='right'>" + Period + "</p>")
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: calculate time elapsed between two concomitant records
This code works only with Form view and NOT in table view...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Paiement status update with "due date" in another table
OK, final proposal... (My setup is for Customer with numeric 'Terms' field) -- let dd := Date + Customer.Terms;let pd := 'Pay Date';if pd = null then"Not Paid"elseif pd > date(dd) then "Overdue" else…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Paiement status update with "due date" in another table
Ignore my previous post... Create a formula field in the payments table -> 'Due Date' = Activity.'Due Date' then in the Status: if 'Pay Date' <= date('Due Date') then"Paid"elseif 'Pay Date' >…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Paiement status update with "due date" in another table
Try this -- if 'Due Date' != null and 'Due Date' = 'Pay Date' then"Paid"elseif 'Due Date' != null and 'Due Date' < 'Pay Date' then"Overdue"else"Not Paid"endend -- Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do I delete a database?
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Control to view web page?
This is problematic on iOS (iPhone 7). If I browse a record that have an web address in URL field, Ninox.app return to home page and freezes.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Change the sequence of the tabstops
@Mac4Me If I understood your question correctly, you can't change the sequence of the tabstops (as far as I know). You can change the order of the fields if you want. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula to Print an Save
Look here: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/attach-file-5b5d77049b4f220718cdba4d?post=5b5dabbe615501550d8cbcf4&page=1 Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Linked tables
Thanks again @Leo, and "one more thing", the new feature "View" is fantastic! Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Linked tables
Thanks Leo for the info... And, while we are here, can we use more than one "on create" trigger? Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 27 28

Back to top

Ninox-Documentation

Overview

View all topics