Mel Charles

Mel_Charles

England. UK

1327
181
1

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

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

My Posts

Latest Posts

Re: What is limits for Ninox Cloud
I use cloud version fro my business and find it find. what do you mean by limit. speed/data/functionality etc? in short have as many useres as you require approx $10 per user per month each user gets…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Styeven I can't believe I missed that! Sometimes you can't see the wodd for the trees! Thank you for the casting the fresh pair of eyes over the script.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
I agree All other software I have used has allowed even the text/number input fields to be coloured. I like to have my cost price fillds in a light grey but to get around this I have to add a formula…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
Hi Jan Ninox has a few quirks on formulas you can add colour to text pert and background on the full cell width on things like combo boxes it will only aloow it to set the background color to the…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
ignore the text type in subject line !
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
emailing list of contacts not changing the firstname in list

I have done a script to send an email to all valid contacts to update the prices. It all works fine except that I have an issue in that the contact first name is only picking up the name of the…
- Mel_Charles
- 3 yrs ago
- 20replies
- 897
- Get help
Re: Date calculation
using todays date then it is .... today() + 120 or if reffering to an exsisting field.. example - if your field is called say xDate you could also add a formula field and in that field add the scrip…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
oops image whent in a bit small!
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
Jan Yes as you can see in screen shot - the child table has colour field in it as stated you can only set colots against formula fields/various controls & fields where you can set conditional…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
Jan the whole field can have a backgound color (formula field only + plus other controsl but not input fields
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Steven/John Applogies for late reply but I wanted to test logging in a few days to ensure that above skips the weekend to look for mon/tues promise dispatchby dates.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
I can't seem to get global scripts to accept weekday without an error so had a thought and decided that what if I set the code out aas follows! let d := today() + 2;let e := today() + 3;let f :…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Okay - so ther is an obvious flaw in my logic in loggin in today (Monday) then the promised date check is 2 days awy (wednesday) great that is until I get to thursday or friday when it will try to…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Yes John I was finding that some time I could trigger and not others when testing greater than - less than and equals In the end i tried so many variations that i got tottally confused !…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi Steve Both of your suggested methods WORK !!! albeit the second seems slower to perform so going with the first option Thank you both John/Steven for the hlep on this:-)
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi John Sorry tested a variation and copied the wrong one to above. Thank you but even with your suggestion - I'm still stuck...- If i put this script onto a button directly on the form the alert…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
Hi John Basically, my take on this was that all my production had been on Sapphires Dataease right from it’s DOS days back in early 1990’s and had grown up through the various upgrades.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
Cheers Sean - I can use that !! Jess - Glad you are sticking with it. After some 2 + years of working with Ninox- I am still learning, But I managed to bring forward my 4 year plan to run most of my…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi John Okay that makes sense thank you. I have tried your line but it still ignored thus i tge case of this test below no alert pops up if cnt(select JobDockets where DispatchBy = now()+ 2) > 0 then…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Ninox changed the above script wher i had the brackets so should have read like this if (select JobDockets.DispatchBy = today() + 2) then etc even so script is still ignored
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
also tried if (select JobDockets).DispatchBy = today() + 2 then etc etc but this is ignored completely ?
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Nope .. I'm making a pigs ear of this.. the following is what I am trying to achieve ... in Global Trigger select JobDockets where DispatchBy = today() + 2;sendEmail({ from: "mel@testemail.co.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
Sean I'm on thr brower version. It would be helpful to know wht the first hack is. Jess. I agree there a few things in Ninox that they need to play catch up on.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: is it possible to copy a view?
yes you can copy table veiws etc. Hightlight the veiw. then press the plus in the view listing and give it a new name. this create a new view with all the info from the one you started with.
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Arrgh..... sorted it myself being stupid- got this omplety wrong - Pleaase ignore me I need .... select JobDockets where = DispatchBy = today() + 2 etc.... ;
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view

1 33 34 35 36 37 54

Welcome to the Ninox community

Mel Charles

My Posts

Re: What is limits for Ninox Cloud

Re: emailing list of contacts not changing the firstname in list

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: emailing list of contacts not changing the firstname in list

emailing list of contacts not changing the firstname in list

Re: Date calculation

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Re: Why can't I move these formula fields?

Re: is it possible to copy a view?

Re: Testing a due date from the Global Trigger after open

Overview