Mel Charles's Profile | Ninox Community

Latest Posts

Re: Single Dynamic field that populates other fields
@Fred yes Fred. Weeding out as many selects as I can. As db currently has some 860,000 records in main table. it is worth doing ! where I can’t then I limit the amount of data I pull into views etc
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
@Fred Wow - Works buddy ! Top man ! Thank you sir 😁 Not done much with Ninox dynamic links to date (as did stuff prior to the releasing and saw no need to change what was in place until now Still…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
Hey Fred The first one goes in and is accepted but it returns an email that is not associated with the customer contact The relationships flow is this Table : Customers Sub Child Table :…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
Hi Fred oh cheers i will give these a go Econtact pulls from Contacts table which itself is a child of customers
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Single Dynamic field that populates other fields

I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…
- Mel_Charles
- 2 yrs ago
- 7replies
- 58
- Get help
- Answered
- Answered
Re: "empty" option in Dynamic Field pick list
@Rafael Thats does it for me - Perfect ! 👍
- Mel_Charles
- 2 yrs ago
- Learn and share
- Reported - view
"empty" option in Dynamic Field pick list

Does anyone know how to get rid of the system generated "empty" option in a dynamic field list?
- Mel_Charles
- 2 yrs ago
- 2replies
- 64
- Learn and share
Re: Images size on printouts
Roger Thanks Roger but I think that leaves you on the staring grid just like me - I have not been able to sort it even on the newer dynamic print forms!…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Relationship between 2 tables - how to?
To echo above - I would definitely stay away from creating multiple fields of the same data on the same table - you will heading for trouble - Ninox is a relational database and makes it easy(ish) to…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Spinning circle most of the time
I rarely get this - however over the last 2 weeks I got it a lot. So I asked Ninox to move my workspace onto another of their newer servers and hey presto the problem has gone !
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: import duration values from Google Sheets
sc You are welcome Stig - Anytime 🙂 Yes the HD arrangement is both beautiful & moving. https://www.youtube.com/watch?v=yb9tHjuy9Hw (Organ Accomp) https://www.youtube.…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: import duration values from Google Sheets
sc What - like something like this? I've only a very done a rough sample DB Your diary dates will appear in the calendar. I guess you could enchance it quite nicely Ensure you sing some Handel tunes…
Attachment
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
RoSoft_Steven Just I case I didn't make it clear or forgot to say so. Steven you are a complete star! The solutions issued by you is breathtakingly superb!…
- Mel_Charles
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: import duration values from Google Sheets
Make sure you set the field format before you do the import tho... :-)
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: import duration values from Google Sheets
sample record imported and here it is on the table
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: import duration values from Google Sheets
Ninox has the following Date Field, Date & Time Field and Time Field. So you want the latter! plus the Ninox import routine
- Mel_Charles
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven I couldn't wait until tonight so in the copy of my live DB with the test table There we 370 with either 1, 2 or 3 or images in them. Total image count was around 580 - however the…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven I have had comms with support. They have stopped the server session and restarted it. I have now run all 3 scripts in YOUR database and they now work.…
- Mel_Charles
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven Okay so all of the scripts above were copy pasted into both your database and mine. I ran the version this morning (delete one file at a time) in both yours and mine and they both…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
RoSoft_Steven Thank you I have tried all 3 version on a test table the contains 370 records with either 1 ,2 or 3 images (paperclip attachments) per record 1.…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven Thats great thnk you. I have trieed the all 3 versions Deleting ONE image at a time in ONE record - this script Works and files are deleted Deleing ALL images in One record - Runs to…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven That is fantastic my friend !!! I can make great use of both the per record basis and global for the table - !! re the question of per record.…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven Out of interest, is this script intended to delete all attachments to all records. as far as i can see it it deleting a single attachment ie if there are 3 shown on the paperclip then…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven Thats great thank you, your sample makes sense to me. I have not touched anything relating to API before so very much learning this as of now.…
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view
Re: Delete Files added to paper clip
@RoSoft_Steven use the API is a little over my head can you explain how I would use it ?
- Mel_Charles
- 2 yrs ago
- Get help
- Reported - view

1 10 11 12 13 14 54

Welcome to the Ninox community

Mel Charles

Re: Single Dynamic field that populates other fields

Re: Single Dynamic field that populates other fields

Re: Single Dynamic field that populates other fields

Re: Single Dynamic field that populates other fields

Single Dynamic field that populates other fields

Re: "empty" option in Dynamic Field pick list

Re: Images size on printouts

Re: Relationship between 2 tables - how to?

Re: Spinning circle most of the time

Re: import duration values from Google Sheets

Re: import duration values from Google Sheets

Re: Delete Files added to paper clip

Re: import duration values from Google Sheets

Re: import duration values from Google Sheets

Re: import duration values from Google Sheets

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Re: Delete Files added to paper clip

Overview