Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: What's with all the garbage
Hi Dan, thank you for the tip, seems like l have just been smacked
. Not up with etiquette on forums just saw the massive amount of spam and this thread was the open.
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Learn & Share
Reported - view
Re: What's with all the garbage
Hi, l am wondering if you might be able to help. I spent quite a few hours today making changes and cleaning up my data base, along the way l saved and made back ups.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Learn & Share
Reported - view
Print all records in date range.
Hi, l would like to print all invoices in a date range. Is there a script for a button l can use? I'm sure this question has come up before but struggling to find anything on the forum.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
2
replies
257
Get help
Re: Help with a new connect view with dashboard button....
Thanks John, works brilliantly, really appreciate your time. regards Michael
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with a new connect view with dashboard button....
Hi John, sorry for late reply. Yes l do want to be able to print the 'view', the name of the field is called Amt_Outstanding and is a formula field numeric.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Help with a new connect view with dashboard button....
l recently added a connect view with dashboard to show all invoices in a date range. I was wondering if someone could help add to this formula so that l can add another button with the same formula…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
5
replies
266
Get help
How to remove a record
When you have added a record using the "add existing" and you realise you added the wrong record, how do you delete record without deleting the original. thank you Michael
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
1
reply
224
Get help
Re: Help with last Formula...
Hi John, This is the formula used in the View Table. let myCust := CUSTOMER;let myFrom := From;let myTo := To;select Invoices where Customer = myCust and 'Date of Invoice' >= myFrom and 'Date of…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
Hi John, this is the formula that was suggested first, which only gave me the total of all invoices. I was really after a formula to sum all Customer.Shop Sales which is what he kindly supplied in…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
Yay... thank you for helping with that. I know that it's all logic but I could not make it work. You can spent hours down the rabit hole that is Ninox. Much appreciated and hope that this might help…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
You can see from the screen shot that the total in the View for 'Total inc GST' is different to the sum in 'Shop Sales' The screen Shot above is when I just have the .'Customer.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Help with last Formula...
Hi John, the formula you gave gives me a Total for all invoices, I am looking for a formula to sum all invoices of one customer. I did try re sum( Invoices['Date of Invoice'>= xBeg and 'Date of…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Help with last Formula...
let xFrom := From;let xTo := To;let Cus := CUSTOMER;sum(Invoices['Date of Invoice' >= xFrom and 'Date of Invoice' <= xTo].Customer.133) This does not return the amount shown in the view of Total Shop…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
13
replies
673
Get help
Re: Connected viewed records with a view - One Customer
Hi Nick, thank you for your efforts l have copied your able to a "T" The last things l need to finish this report are.... l have 4 formula fields Total , all Sales Payments , all Sales Owing ,…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Re: Connected viewed records with a view - One Customer
Hi Nick, this has helped and l am one step closer to my goal. I now have a view called Shop_Sales_Report and with your formula it shows all shop sales.
so now l would like to do a connected viewed…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Connected viewed records with a view - One Customer
I have copied a Connected view formula from Webinar 2021 112-Print view element in dashboard which is brilliant, thank you to the person who added that.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
4
replies
403
Get help
Re: Sum a customer sale in a view
Hi John, l have a table called "Invoices" and a table called "Customer" with the link from Customer to invoices. The field l want to total is called 'Total inc GST' The Customer is called Shop Sale…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Sum a customer sale in a view
I would like to sum all Sales for a customer in a view table shown in a formula field. l have let xBeg:= 'Beg Date' let xEnd:= 'End Date' sum((select Invoices) ['Date of Invoice'>= xBeg and 'Date of…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
3
replies
395
Get help
Re: Help needed with invoicing
Hi Fred, on the customer table l do have a script in a button to automatically open a "Shop Sale" invoice and which auto fills the date. The script for button is let newRec:=(create Invoices); newRec.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
Get help
Reported - view
Help needed with invoicing
Hi, it's been a while since l have posted but have come across a problem l don't know how to rectify. l have an Invoice table linked to a Customer table,…
Michael McKenna
Central Park Furnishings
Michael_McKenna
1 yr ago
5
replies
473
Get help
Date range and the Ninox Id..
Hi, I have been struggling with the date range and Invoive Id system I created for some time. I have sorted the Invoice system, thanks to Steven and I may have sorted my date field.…
Michael McKenna
Central Park Furnishings
Michael_McKenna
2 yrs ago
282
Get help
Question about date fields ...
When placing a date field onto a form do you then have to format that 'date field' to the way you want to see it for every usage. ie, format(Date,"DD/MM/YYYY") Michael
Michael McKenna
Central Park Furnishings
Michael_McKenna
2 yrs ago
178
Get help
Date format issue.
Hi , l have brought this query up before but not had a response. I have 3 team members under my data base, one of these team member dates are formatted to the American format ie,…
Michael McKenna
Central Park Furnishings
Michael_McKenna
2 yrs ago
1
reply
254
Get help
1
2
3
4
Next
Michael McKenna
Michael_McKenna
Central Park Furnishings
88
0
0
Joined: 16 Oct 2020
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags