Mel Charles's Profile | Ninox community

Badges

Latest Posts

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
- 38
- 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
Odd behaviour on number fields

Have a slight strange issue on a pricing panel On a quick quote form I have some cost/sell fields and users are encountering an issue with tabbing out of the cells versus hitting the Return/Enter…
- Mel_Charles
- 3 yrs ago
- 25
- Get help
Re: Suggestions from May 2022
PLEASE DON'T ADD ANY MORE COMMENTS TO THIS THREAD !!! As i said earlier . Ninox are not reading this thread and They have not replied in any form regarding the earlier collated list of ideas.…
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Database size spiraling out of control
Simon Have you tried a screen share with support to see if they can get to the bottom of your issues. I restore files regularly for testing etc. and simply not getting the issues you are…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Database size spiraling out of control
I can vouch that having the restored database added to the pot with (restored) appending its extremely useful ! - as you know exactly where you stand and as sean says it's a easy to rename it too.
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view

1 24 25 26 27 28 55

Welcome to the Ninox community

Mel Charles

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

Odd behaviour on number fields

Re: Suggestions from May 2022

Re: Database size spiraling out of control

Re: Database size spiraling out of control

Overview