Mel Charles

Mel_Charles

England. UK

1284
172
1

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

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

My Posts

Latest Posts

Re: How do you create a Google map with multiple locations?
Someone created an elegant multi point map which might be of interest to you follow this thread and the various links https://forum.ninox.com/t/q6hrmdv
- Mel_Charles
- 1 yr ago
- 1
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 7replies
- 49
- Get help
- Answered
- Answered
Re: "empty" option in Dynamic Field pick list
@Rafael Thats does it for me - Perfect !
- Mel_Charles
- 1 yr 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
- 1 yr ago
- 2replies
- 55
- 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: import duration values from Google Sheets
sample record imported and here it is on the table
- Mel_Charles
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 8 9 10 11 12 52

Welcome to the Ninox community

Mel Charles

My Posts

Re: How do you create a Google map with multiple locations?

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

Overview