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: while loop stops before reaching end
Nick - If not using Ninox anymore what have you migrated onto?
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
Also tested your imported DB. Like John's test it worked fine. However - When I tested your script on your opening thread (i copied it) it created the records in the blink of an eye.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: URL Field expands off layout view
Which app is this on - i'm on the mac cloud version and it works perfectly no matter how much= I expand or condense the window size - it always truncated the etc off to the right hand edge and it…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Printing a Ninox table as a PDF with Images
Rafael - you can create your 1 reports then save it the creat a new (copy) based on the report with a new name to give you multiple copies - of which you can then edit slightly
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Print Layout: Sorting a subtable via a 'hidden' field?
@Rafael Yes - I use several landscape forms... here is one (test) Just set the page boxes like this !! 297 in left box and 210 in right box on the designer
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Admin mode toolbar hides field at bottom of view! Help?
Not Aware of an issue with this.... But you should be able to click the edge of the form drag to expand the form to get the bar out of the way. However if a real pain then click on Edit Fields and…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Open....
@RoSoft_Steven No mate- on the first tab it won't trigger unless as stated you go in firm (not worked exit then go in again (works) same for every record also tried to ur script on global - but its…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Open....
re first tab - Found it also works if you go into the form then close it then go back in... but not in all cases - weird !
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Trigger on Open....
@RoSoft_Steven This is a good idea, as I have longed since wanted an event to trigger on OpenForm or CloseForm (without having to update something) Your idea works on all tabs after the main page on…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Print Layout: Sorting a subtable via a 'hidden' field?
Yes there is an answer but you won't particularly like it! Firstly - Ninox have yet to date not addressed the matter for formatting views on a print layout form - is has been on a wish list for ages…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Display immedialty data entry mask
if so then there is some limited format options for a given field in edit mode like this- but i don't think there is a way the pre show the mask or create custom masks at input time Input mask are…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Display immedialty data entry mask
re you suggesting you want to display a DATA INPUT MASK as per ms access/dataease etc. when say a telephone number filed would show __/__/__ so it gives the user a clue as to the format of the entry…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
Or if it is not too sensitive - how able you load a copy of your db/table here and we can try that db locally and still see if it screws up!
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
I have had another go at this and to be honest I cannot get it to fail. I am still interested why the code run created 101 lines. So if i have it right the first line already gave the variable start…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: wrap text??
So okay tested in with a normal text field. here is my field on the form. You can see the text fills the field and the text is truncated. In the print design edit mode - you select the field and…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
Sorry I don't know - I'm totally on the cloud version
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@Kent Signorini To be fair Ninox is pretty awesome. I used it for last 2 years and I have managed to move a whole load of my business processes onto it.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
this is probably taking you further way from where you want to be - but on some of my tables I have hidden the add/deletion buttons as per this thread https://forum.ninox.com/t/g9hrtf1 from @Sean ..…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
Yes it will be 9 - but as you say you deleted the old 9th record - thus ninox no longer knows that that record existed. If you must preserve that record.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: wrap text??
Have you tried using a multi line text box instead?
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@John Halls Wouldn't like to comment John I keep things simple cos i'm incapable of thinking any deeper
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Emails (Improving on what I do)

For some time I have been using 2 type of emailing from with Ninox. Type 1 : Order Confirmations etc - Where I use scripts and html fields to send personalised data via button using sendEmail.…
- Mel_Charles
- updated 3 yrs ago
- 28
- Get help
Re: while loop stops before reaching end
Hmmm a bit lost how to advice you further other maybe you ask support to do a screen share and take a look !
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
and here is my simple one for adding a job bag number - this is placed in the trigger on new record in the table let before := max((select JobDockets).'Job Bag'); 'Job Bag' := before + 1
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: while loop stops before reaching end
I too created the DateSeries Table Copied the above script into a button on one of my other forms. and pressed go! It created the table no problem - id rec from 1 - 101 (i'm guessing the while does…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 54

Welcome to the Ninox community

Mel Charles

My Posts

Re: while loop stops before reaching end

Re: while loop stops before reaching end

Re: URL Field expands off layout view

Re: Printing a Ninox table as a PDF with Images

Re: Print Layout: Sorting a subtable via a 'hidden' field?

Re: Admin mode toolbar hides field at bottom of view! Help?

Re: Trigger on Open....

Re: Trigger on Open....

Re: Trigger on Open....

Re: Print Layout: Sorting a subtable via a 'hidden' field?

Re: Display immedialty data entry mask

Re: Display immedialty data entry mask

Re: while loop stops before reaching end

Re: while loop stops before reaching end

Re: wrap text??

Re: Auto-increment?

Re: Auto-increment?

Re: Auto-increment?

Re: Auto-increment?

Re: wrap text??

Re: Auto-increment?

Emails (Improving on what I do)

Re: while loop stops before reaching end

Re: Auto-increment?

Re: while loop stops before reaching end

Overview