Mel Charles's Profile | Ninox community

Badges

Latest Posts

Re: Need Help with view table.
To be honest - it has just dawned on me that this really is only another way of saying show hide the form. The only difference is that you either see the grid or not - so you could go on to display a…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Need Help with view table.
@Rafael so in my table above there are 2 fields that work together to filter the data in the table view. (Search Items and Search Ref) so in the clear button for my example you only need 'Search…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Unique Value Formula
@RoSoft_Steven thats a good idea Steven - I don't like the idea of deleting a name in middle tho. I much prefer never to delete a name etc but archive or flag name as deleted that way your number…
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Need Help with view table.
Fred / Rafael- I could not ever get this to work with either Null nor " " (obviously hide form view - will work) but I want to leave the grid visible at all times I did get around it by piping a…
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Calendar event details
You can used a text field as a landing field in Calendar best explained if you watch this video https://ninox.com/en-tutorials/200-04-date-time-fields-and-the-ninox-calendar
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Unique Value Formula
There maybe more elegant solutions to come on this but In one of my early databases, I used a simple solution of the username plus a separate incrementing number field.…
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Why can't I duplicate a table with all its data?
Seems a fair question Why not send support a feature request and I will do the same I will also add - please add a tick option for exports to say export all fields (not matter how many/few are shown…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Those pesky hidden fields....
Good idea and worth noting as I have dozens of hidden fields!. I also have another way I do it. I give the would be hidden fields number in their "display field only if" ,attribute ie if Lock = 2468.…
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Proper Case code sample
you just want lower(string) then ... if you want all to be lower case
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: auto populate email field
@Jarno Vande Walle Yes I know it requires SendMail but you asked me for the information re attachments. 🙂 re using outlook client - yes you can get the email box populate I have explained this above
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini Neat ! 😎
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: auto populate email field
Jarno You said you want to copy the email from a linked table ? as along as you have a link you should be able to extra the email from the other table record.…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Screenshots?
@Alan Cooke I agree with Alan - definitely worth doing this otherwise fields jumapround
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Server slowdowns !?
@Jacques TUR No - seems okay my end, working super fast as usual
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Sub table To a tab
or again in design mode go into "edit fields list" and move the sub-table name up or down the list to where you want it.
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
here are some functions that are not supported on triggers ("on create" and "after update" in the table) in the web browser version but only in buttons and on the "Trigger after open" in the database…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@Kent Signorini Steven has given a great answer to your first question (as usual 😉 I too and on the web version (multiple users) and have no issues generally with forms scripts running for New or…
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: auto populate email field
Jarno - there are a few ways to do it but a simple way from buttons etc This one of the ays I do it on my job dockets forms So on my my customer card Table I have a field called email now on my…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Current Storage Capacity
On your database page on your right gear icon you will see usage I am on web version but am guessing it is same for all?
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Sub table To a tab
drag it in design mode onto the tab you want is one way
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Screenshots?
Couple of practical screen shots
- Mel_Charles
- 3 yrs ago
- Learn and share
- Reported - view
Re: Check if 7 fields have been filled
@RoSoft_Steven the button to mark as answered only shows for the originator of the particular post
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger when a new record is created
@webmaster.antonioferriero Can't say if there is a list but that answer I gave you was what support gave me to the same issue some 6 months back
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Trigger when a new record is created
There are some functions that are not supported on triggers ("on create" and "after update" in the table) in the browser, but only in buttons and on the "Trigger after open" in the database options:…
- Mel_Charles
- 3 yrs ago
- Get help
- Reported - view
Re: Timer for delete record
As Fred states .... You can automate in a kind of way by tracking the current date less x I used this code in the GLOBAL script area to delete old jobs and its associate child forms over approx 6…
- Mel_Charles
- 3 yrs ago
- 1
- Get help
- Reported - view

1 21 22 23 24 25 55

Welcome to the Ninox community

Mel Charles

Re: Need Help with view table.

Re: Need Help with view table.

Re: Unique Value Formula

Re: Need Help with view table.

Re: Calendar event details

Re: Unique Value Formula

Re: Why can't I duplicate a table with all its data?

Re: Those pesky hidden fields....

Re: Proper Case code sample

Re: auto populate email field

Re: Structural Problem - How to choose multiple items to add to an Invoice?

Re: auto populate email field

Re: Screenshots?

Re: Server slowdowns !?

Re: Sub table To a tab

Re: Two Serious Problems... Required Fields & Trigger on new record/update

Re: Two Serious Problems... Required Fields & Trigger on new record/update

Re: auto populate email field

Re: Current Storage Capacity

Re: Sub table To a tab

Re: Screenshots?

Re: Check if 7 fields have been filled

Re: Trigger when a new record is created

Re: Trigger when a new record is created

Re: Timer for delete record

Overview