Mel Charles

Mel_Charles

England. UK

1321
180
1

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

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

My Posts

Latest Posts

Re: Generate QRCode to File or Image field
Works for me on iphone okay
- Mel_Charles
- 1 yr ago
- Learn and share
- Reported - view
Re: <span onclick> , Is it possible in a Formula (html) with for from to do loop ?
@Haavard Hjorteland Have a look at this link re recovering your workspace -in case you store/delete images. so yoy can get backups back! https://forum.ninox.…
- Mel_Charles
- 1 yr ago
- 1
- Get help
- Reported - view
Workspace ! Not being recovered where images are held & deleted.

Storage of image files and deleting them do not automatically give you your workspace back. I have copied this from another post that I answered as it seems to me that other users are now having…
- Mel_Charles
- updated 1 yr ago
- 17replies
- 475
- 1
- Learn and share
Save record to a log file. error

Hmm can't quit get this right I have a script to cycle through contacts table to emails all contacts. which works perfectly. However I now want to as apart of that email process add a record into…
- Mel_Charles
- 1 yr ago
- 2replies
- 31
- Get help
- Answered
- Answered
Re: DB Size Problem
Ha ha - made the wife a coffee and got let of the hook !!!! highlighted text are my table names Button - Delete images in job dockets - This routine is to simply to remove the Field image files (NOT…
- Mel_Charles
- 1 yr ago
- 1
- Get help
- Reported - view
Re: DB Size Problem
Also when you have shredded the files etc. Don't expect the available user space to suddenly record what you have. Ninox say it only updates roughly twice a day.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: double entries
This wont stop the double entry but will flag if an existing field has the same data. ie I use this on a new account customer order id field the code goes into a formula field set to only display…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: DB Size Problem
actual note verbatum !
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: DB Size Problem
I can ! As I have recently been through all this issue and spent many hours going through this in detail with Ninox support! How are you deleting the images?…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Control panel data check
John Here is a very simple way to check if an account (client) already exists. in the case it is just sitting in a formula field in in the example below it tests CustID field.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Relationship between 2 tables - how to?
@sc Okay Makes snese and yes assuming you have out recorded the paying time for each peice in th record then a formula will indeed will sum up the total time.…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
Re: Relationship between 2 tables - how to?
@sc If it were me i would go for 3 tables as a min main form (header dates etc. then a table for songs and table for singers and have songs and singers a sub table on main form I assume that you keep…
- Mel_Charles
- 1 yr ago
- Get help
- Reported - view
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
- 57
- 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
- 61
- 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

1 9 10 11 12 13 53

Welcome to the Ninox community

Mel Charles

My Posts

Re: Generate QRCode to File or Image field

Re: <span onclick> , Is it possible in a Formula (html) with for from to do loop ?

Save record to a log file. error

Re: DB Size Problem

Re: DB Size Problem

Re: double entries

Re: DB Size Problem

Re: DB Size Problem

Re: Control panel data check

Re: Relationship between 2 tables - how to?

Re: Relationship between 2 tables - how to?

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

Overview