Mel Charles

Mel_Charles

England. UK

1321
180
1

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

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

My Posts

Latest Posts

Re: Action after clicking on "send email".
Hi Bernd Okay - Hope you get on okay. There is a lot you can do with script/send email very flexible. I'm having it send confirmation orders/dispatch notes.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Action after clicking on "send email".
Another way might be to try and fool the email field that it has been changed in some way (ie updated) ie have a trigger else where to copy the content of the email field to. a variable.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Action after clicking on "send email".
You might want to consider not directly using the mail client email file directly and using a script the trigger "sendmail" it is harder to implement but gives good flexibvility ie I send an order…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
John - Good luck with that _ I've lost count of the number of times I have asked Ninox to made a required field do what it is supposed to do. (ie nt let you save the form untill you fill in that…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
Oh Steven - Learn something every time from you. I never knew you could put scripts directly against a tab property!! Tried it and works perfectly !!! Not only does it fix John's issue but I can so…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Restrict Duplicate entry
Hmm... if you say it is working on other tables but not just one of them.. I would suggest you send it into support@ninox.com and ask them to do a dial in to look at?
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
Hi John I have tried this but I agree it won't trigger, you could add a formula field onto the form and put that script in it. but of course it will then nag you to death (even on a new record) so…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: code TRIGGER AFTER UPDATE
I didn't add the script !!! DOH! let ChiNo := text(Locations.Consulente);Chi := ChiNo
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: code TRIGGER AFTER UPDATE
oh Good Technically - Doing what you asked for gives rise to a potential issue insofare as it relys on having a combo box in your consulene table and a drop box in the data table field (chi) that…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: code TRIGGER AFTER UPDATE
Hello AdminLike I'm not sure if i have understood you correctly but. I recreated this as best as I can.. Data entry form (Test1) with a linked field (to table Locations - this table has just one…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Need formula for Button to create a new multi line text field
Chris Yes the first idea will work (mostly!) but I fear in time you will find this limiting Have a look at the relationships section in the user guide as a starter also have a look at thr 4 videos…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Need formula for Button to create a new multi line text field
Chris First of all I would state this anser is NOT the most elegent as frankley I would do the above a different way! SO create your button and creat a multline filed (I've called mine memo) the in…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
Hardy I was just answering your question - ie Can you automate it rather than have it triggered by pressing a button. Which you can... by using the " if this fields data has changed can it do the…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
Hardy Depending on what the field (Receive by) is - ie text field I would have though you could test for the script to run on trigger after update on that field.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Problem with printing in Windows and Android.
To be fair - Every time I email support I get an answer! - it is not necessarily the one I always want or expect but ....
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Formula to search records with dates
You have you TO field and your FROM Field and put the above script within the view in the formula section you may not need the do as server (i'm on cloud version) depening on what your on.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Formula to search records with dates
Hi Guiseppe You do something like do as server let xBeg := 'From Date'; let xEnd := 'To Date ;select Job where 'From Date' >= xBeg and 'To Date' <= xEnd end
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Problem with printing in Windows and Android.
Sorry - I can't advise as I totally mac based
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Script: test for null or empty'
Oh - I think I have worked it out !
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Script: test for null or empty'
Davie - Now I know I am getting old - err what is FFS?
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Field alignment logic
John I know how you feel about this, I came to Ninox after some 25 years of using Dataease - whereby like Filermaker/Access etc you have much more control of the table/form elements etc.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Field alignment logic
Sean. Just looked back over my system and found I had not used your CSS hack in my live database but only in my play/development copy. However I have now! so thank you agina (Twice in one day!!!…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Field alignment logic
Sean - the older I get and the more I learn, the more I realise the less I know! :-). Consider my memory jogged! :-) Hmmm - It hard to always advise. Yes I do remember (now!…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Script: test for null or empty'
you email support - support@ninox.com and ask them to give you access to the Webinar EN2022 system there are manay user test Apps on there etc the main ref is called 0001_Ninox Reference (note it is…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Script: test for null or empty'
full blurb from master Ninox Ref
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view

1 27 28 29 30 31 53

Welcome to the Ninox community

Mel Charles

My Posts

Re: Action after clicking on "send email".

Re: Action after clicking on "send email".

Re: Action after clicking on "send email".

Re: Alert message on CloseRecord

Re: Alert message on CloseRecord

Re: Restrict Duplicate entry

Re: Alert message on CloseRecord

Re: code TRIGGER AFTER UPDATE

Re: code TRIGGER AFTER UPDATE

Re: code TRIGGER AFTER UPDATE

Re: Need formula for Button to create a new multi line text field

Re: Need formula for Button to create a new multi line text field

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Problem with printing in Windows and Android.

Re: Formula to search records with dates

Re: Formula to search records with dates

Re: Problem with printing in Windows and Android.

Re: Script: test for null or empty'

Re: Script: test for null or empty'

Re: Field alignment logic

Re: Field alignment logic

Re: Field alignment logic

Re: Script: test for null or empty'

Re: Script: test for null or empty'

Overview