Mel Charles's Profile | Ninox community

Badges

Latest Posts

Re: Status script not working
Hi John cheers - all works thank you I had used both scripty variation and tried other ways but missed the square brackets so why the square brackets to refernece just the field?.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: Problem Ninox
John In my case there was no invite, we were working as normal and then without warning all users were thrown out of Ninox with a session ended and at that point could no longer login.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: Problem Ninox
Yep a lot of people have had the same issue from about last wed. I lost two complete trading days ! Support insisted there was no problem - very annoyed about this ! and orders
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Status script not working

I am having an issue with a script. All appears fine but the status is not updaing and simply defaulting to "Order Complete" The idea is to count up the true 'dispatched' status of each 'Job Lines'…
- Mel_Charles
- 3 mths ago
- 7replies
- 63
- Get help
Re: Something new today. Very annoying.
Yes had exactly the same issue 4 days ago. Threw me and my colleagues out about 20 times on thursday morning (not a joke when you are trying to run a business.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: Unique transaction Number Not Triggering from Embedded View
as Fred states - put irt on the trigger on new record Been working reliably for me for over 4 years and I have over 900k records- mine is on my unique number is on my Job Bag' field.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
to be honest I was kind hoping i could do it like this - but i guess not ha ha let prod := first(select Product where Pcode = this.Pcode); if prod then ItemImage := prod.…
- Mel_Charles
- 3 mths ago
- 1
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Jeez Fred / John - Ninox don't make it easy do they?. Not being a boffin like you guys (strictly in the amateur camp) I learn enough coding to do what I need to do. ie run my business.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
So following on from above tests. I have build my multijob forms proper now I am having an issue with the coping of the product image from the products file to the child table records tho.…
- Mel_Charles
- 3 mths ago
- Get help
- Reported - view
Re: Emailing a set of child attachments
Hi John I really like your approach to this. I am changing they way I do customers jobs, from a single job per record to multi jobs and will need an order acknowledgement for the whole all Order…
- Mel_Charles
- 3 mths ago
- Learn and share
- Reported - view
Re: Printing an attached file
Hi John I have discussed this with the Ninox support times many times as when I print customer quotes I have no choice but to print the quote to an image field - as I want the print file name to be…
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Hi Fred/John/Stephen I woke up this morning to find you have proved a solution. Fred copied your script striaght in to button and hey presto it works. so THANK YOU BOTH!…
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@John Halls ah saw that ! and fixed that one. can;'t issue on the other ref but still have error - so done a drastically cut down copy DB - striiped out loads so will show some reference errors to…
Attachment
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Sorry John that was a typo from in the reply deffo Uppercase J. i can't see a miss reference to a lower case - but will take a deeper look in the morning now...
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@John Halls ?
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@John Halls Hmmm i copied your script and still getting line 8 error..... some minor error on my part i nned to track down then... need a coffee now as getting brain fade !!! 😀
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
deffo parent Quotes (for the 'this' part) and child table is QuoteLines other table is deffo MultiJobs and child is JobLines
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@Fred now done name coorecrtion and if i remove 9-12 it works.... just left with this one error now?
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@Fred @ @RoSoft_Steven ah Yesy I had referenced the view name not the actual child name .
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@John Halls Hi John yes - I know i removed it to try but with a semi colon on end of line 8 that lines then also flags up a as red error too ? 😩
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
copy table record with child records to another table record also with child records

I want top copy a "quote" record that has child lines "quotelines' into a new table record "multiJob" that will also have the copied records "Joblines".…
- Mel_Charles
- 4 mths ago
- 26replies
- 109
- Get help
Re: simple dynamic field - small issue
ah Super guys I did try fiddling with "record" but did not have the syntax right (doh!) so assumed I was way off the mark. Works perfectly so THANK YOU 🙂
- Mel_Charles
- 4 mths ago
- Get help
- Reported - view
simple dynamic field - small issue

I have a small issue with looking up other related data when using a dynamic field so Table1 (Joblines) has the dynamic field in it called Pcode. this is set up point to the lookup table (Products)…
- Mel_Charles
- updated 4 mths ago
- 5replies
- 52
- Get help
- Answered
- Answered
Re: Set a field
Would be good if Ninox gave us the facility to have fixed headers and footers so we could place fields eg totals etc and always have them show. At the moment I have used two workarounds on this Based…
- Mel_Charles
- 7 mths ago
- 2
- Get help
- Reported - view
Re: Image in form keeps jumping left
@Marjolijn By definition all images go to the left on the form - one day ninox will do something about this. I assume you want to move/keep the image to the centre /right of other fields on the form.…
- Mel_Charles
- 9 mths ago
- Get help
- Reported - view

1 2 3 4 5 56

Welcome to the Ninox community

Mel Charles

Re: Status script not working

Re: Problem Ninox

Re: Problem Ninox

Status script not working

Re: Something new today. Very annoying.

Re: Unique transaction Number Not Triggering from Embedded View

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: Emailing a set of child attachments

Re: Printing an attached file

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

copy table record with child records to another table record also with child records

Re: simple dynamic field - small issue

simple dynamic field - small issue

Re: Set a field

Re: Image in form keeps jumping left

Overview