Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Nick
Nick
Greece
673
15
1
Joined: Wed Jan 01 00:00:00 UTC 2014
Follow
My Posts
Latest Posts
Re: zipcode field removing leading zeroes
You need a 'Text' field and not numeric.
Nick
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Button Save Record
Try: openTable("tableName", "viewName") Nick
Nick
Nick
5 yrs ago
Get help
Reported - view
Re: Transfert estimate record to invoice
Finally works!!!! Thank you Birger and, of course, Thierry... Nick
Nick
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Transfert estimate record to invoice
+1000
Nick
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: How do I delete a database?
Nick
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Linked tables
Thanks again @Leo, and "one more thing", the new feature "View" is fantastic! Nick
Nick
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Linked tables
I don't think this is possible, or at least I don't know how... There are links between: - Customer -> Invoice - Invoice -> Invoice Items - Invoice Items -> Products but there is NOT:…
Nick
Nick
5 yrs ago
Get help
Reported - view
1
21
22
23
24
25
26
27
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics