How to enable Javascript

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
- 2replies
- 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
- 5replies
- 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
- 1reply
- 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
- 13replies
- 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
- 4replies
- 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
- 3replies
- 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
- 5replies
- 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
- 1reply
- 254
- Get help

1 2 3 4 Next

Michael McKenna

Michael_McKenna

Central Park Furnishings

88
0
0

Joined: 16 Oct 2020

Follow