Mel Charles's Profile | Ninox community

Badges

Latest Posts

Re: Status script not working
Thank you for the help and explanation
- Mel_Charles
- yesterday
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Fred - I am going to have to come back to you on this. At the moment I can't quite get my head around your suggested code and as to how that will sit in my script I need a quiet evening and lots of…
- Mel_Charles
- 3 days ago
- Get help
- Reported - view
Re: Status script not working
Hi John/Fred Yes of course! - (i am a dummy !) I have always known about yes/no fields having 3 states and do test for this this in many other areas other forms etc.…
- Mel_Charles
- 3 days ago
- Get help
- Reported - view
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 days 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 days 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
- 4 days 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
- 4 days ago
- 7replies
- 44
- 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
- 4 days 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
- 10 days 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
- 2 wk 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
- 2 wk 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
- 2 wk 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
- 2 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@John Halls ?
- Mel_Charles
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 26replies
- 68
- 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
- 1 mth ago
- Get help
- Reported - view

1 2 3 4 5 55

Welcome to the Ninox community

Mel Charles

Re: Status script not working

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

Re: Status script not working

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

Overview