Mel Charles

Mel_Charles

England. UK

1284
172
1

Joined: Sat Dec 14 17:00:37 UTC 2019

https://www.118printgroup.co.uk

My Posts

Latest Posts

Re: Warning / alert triangle on Table name
The warning highlights when there is definitely an issue. it may not at that time be giving you a functional error - but you may have not have triggered a condition for it to do so yet.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Conditional Formatting Advice Please
I do something similar to highlight proof days ie if over x days pop a proof flag (and you could also colour them for your qty's
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Conditional Formatting Advice Please
@Alan Cooke what about ">=1"?
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Conditional Formatting Advice Please
Could you not use " > 0" ? or you could add the formula and put count (QUANTITY) >0 this would return a true (yes) then you could count that formula Coloumn not elegant - just thinking off top of my…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor NO Buddy - Not so grand as a designer. but do I own a print and branding company. Just for information... My approach to this is ever so slightly different insofar an I don't use a yes/no…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
Taylor Ah ha same industry as me !!! Yep all my quotes use a master header form main quote detail and subform(child) for the quote lines etc. See my thread here on how to deal with the auto Quote or…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Automatic incremental numbers (modifiable)
I would also advise you to put the number field say on another tab on the form and have a formula field on the front form to point to it for reading purposes.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Automatic incremental numbers (modifiable)
In edit mode of the table form put in the trigger on new record section this script let before := max((select JobDockets).'Job Bag'); 'Job Bag' := before + 1 change jobdockets for the name of your…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: clearing the Filter option in a column on closing a view
Im on web version and db owner. Mine does this table A view 1 (filter say customers to show ARM) data limit applied switch to view 2, same table. customers shows all data.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Version 3.9x
Process Monitor - I understand this is only available in enterprise private cloud version. not public cloud or apps.
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Message in Print pdf when..
Just add a formula to the print layout and put something like if FieldA > " " then "Con Il primo iorno di etc etc " FiledA is what ever your field is called use the style the make bold etc When you…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: is there a better way to send more "styled email"
@RoSoft_Steven Cheers buddy - I will take a look thanks :-)
- Mel_Charles
- 1 yr ago
- 1
- Learn and Share
- Reported - view
is there a better way to send more "styled email"

I regularly send my customers job status reports as the order progresses through our system ie Thanks for the order - your job is in production etc. originally,…
- Mel_Charles
- 1 yr ago
- 2replies
- 135
- 1
- Learn and Share
Re: do as... massive speed improvement
Yep Using do as ... does make a considerable difference - especially if you are on the web version and have big data tables, cos all the processing is done at the server end before handing it back…
- Mel_Charles
- 1 yr ago
- Learn and Share
- Reported - view
Re: Close all windows except the active one
@RoSoft_Steven Simple - Elegant and yet end result = Fantastic ! My mouse button thanks you Thats the beauty of this forum, you get those "why didn't I ever think of that" occurrences !
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: v3.9 is now live
@Fred You actually received an email - wow !
- Mel_Charles
- 1 yr ago
- 2
- Learn and Share
- Reported - view
Re: Dynamic Reports - my first attempt
@Fred Yes carbone or whatever very SLooooow to generate the reports. I deffo would like to use this feature but the moment I can't put up with the in consistency for now.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports - my first attempt
@RoSoft_Steven reloaded it umpteen times!....
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: v3.9 is now live
and since 3.19my History is totally trashed (even if I load known working backups). Its a good job my outlook is to only look forward Ninox support ar e a bit stumped but are looking into !
- Mel_Charles
- 1 yr ago
- Learn and Share
- Reported - view
Re: How to get passed time in months from two dates?
@Fred Way to go man. You just solved a problem for me to that I did not know I had. Just got asked this week by one of my team - if I could add the facility to calculate when a customer orders a…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Override result in formula field
Davie John's advice is good. Similarly I have a cost - Markup % and Total fields (all input fields instead of having the total as a calculated formula).…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports - my first attempt
Set one up exactly with a table and filed name excatly as on Ninox own screen shot above even with a few camel variations Guess which one worked ? Name of Company {d.customers.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports - my first attempt
I had a stored database with some dynamic forms that all worked (albeit there was a few issues with child sub forms in terms of picking up all the relevant lines).…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Dark Mode
There's a freebie web version called "DARK READER" but I much prefer Sean's version as being colour blind his colour choices work better for me to see the text etc.…
- Mel_Charles
- 1 yr ago
- 1
- Learn and Share
- Reported - view
Re: Dark Mode
Jacgues - Ah cool .... and thats software for you ! I just booted up this morning and it worked and thought oh silly me I should have totally rebooted in the first place!…
- Mel_Charles
- 1 yr ago
- 1
- Learn and Share
- Reported - view

1 11 12 13 14 15 52

Welcome to the Ninox community

Mel Charles

My Posts

Re: Warning / alert triangle on Table name

Re: Conditional Formatting Advice Please

Re: Conditional Formatting Advice Please

Re: Conditional Formatting Advice Please

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Automatic incremental numbers (modifiable)

Re: Automatic incremental numbers (modifiable)

Re: clearing the Filter option in a column on closing a view

Re: Version 3.9x

Re: Message in Print pdf when..

Re: is there a better way to send more "styled email"

Re: do as... massive speed improvement

Re: Close all windows except the active one

Re: v3.9 is now live

Re: Dynamic Reports - my first attempt

Re: Dynamic Reports - my first attempt

Re: v3.9 is now live

Re: How to get passed time in months from two dates?

Re: Override result in formula field

Re: Dynamic Reports - my first attempt

Re: Dynamic Reports - my first attempt

Re: Dark Mode

Re: Dark Mode

Overview