Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: How to copy a row or just few collummns from one table to another using a button
You can give the Inventory recor a handle and then use it, such as let a:= this; let c := (create 'Delivery List');c.(Delivery_Field1 := a.Inventory_Field1);c.(Delivery_Field2 := a.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: product(array)
I'd be interested to ask what the use case is as I've never had to find the product of a large set of numbers. I imagine it won't be the speed if iteration that will be the problem but just how big…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Well done. Come back anytime you have a query.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
A view is not a link, its an element you can add to your form. It takes a formula which returns a set of records. These can be related to the table the view is on,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Having more than one relationship between two tables can be a useful thing, for example a customer may have more than one contact associated with it, but one main contact and to have two…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: product(array)
Hi UKenGB The join function will turn an array into a string and you can choose how to concatenate this. If you choode "*" then the resulting text field can be evaluated.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to e-mail with record in PDF attached
Hi Martijn I tested some code based on your construction and it sent emails perfectly. In your code to send Invoices you have let a := (select RELATIONS where Id = xCust and 'E-MAIL INVOICES' = true);…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Change colour of a formula box if it’s a year later
Hi Nick I hope you don't mind but I would just have let t := days('Last Updated', today());if t > 365 thenstyled("Expired", "red")elsestyled("Not Expired", "green")end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Seems basic math and date function are bugged
Hi Daniel Neither of the functions have bugs. Sorry to say I don't think your solution is correct. You problem was really quite hard to solve and it boils down to three elements. 1.…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Trigger on Update not triggering
Did you try swapping out duplicate for create? I think you will find duplicate is the source of the bug. I can show you my test code if you would to see it.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Thanks Alain. I would never have worked that out. Time to learn a bit about Regex...
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Thanks Alain I must have soent an hour trying to do that and could not for the life of me get to grips with it. Could you explain the regex expression and what the g and $1 are.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Hi Jan How about let w := "John F Kennedy";let i := ""for a in split(w," ") doi := i + substring(a,0,1)end;i Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Update not triggering
OK, after extensive testing I was able to mimic the behaviour you were experiencing (button vs trigger etc) and find the culprit. I have to concur that it's very odd.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Update not triggering
With a button you are chosing when to run the code and with a Trigger on create: you are running the code just once but with a Trigger on update: you are running the code on every update so you need…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Code help please
Hi Faldo This code can be shortened to for i in select Table1 where 'Yes / No' = true do let t := (create Table2); t.( firstname := i.firstname; lastname := i.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Is something odd is going on with the Forum dates

I've had a few notifications today regaring threads I have replied to but when I check them out there are no additional posts. The 'Latest Activity' dates are fine but looking at the dates for posts…
- John_Halls
- 3 yrs ago
- 2replies
- 133
- Get help
Re: Setting up a FIFO inventory
Hi Yannick I've mocked up a solution. It uses two tables, Inventory and Transactions. Transactions is used for both stock coming in, and for stock going out.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Copy field contents into another linked tables field
Hi David Just to say sorry for my erronious code earlier. I normally mock something up and check it works as intended before posting. I concurr with all the other comments and Bill's solution is a…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Copy field contents into another linked tables field
Hi David Assuming your relationship links are named after the tables EITHER - In the in the Trigger on new record of the Drawings table add this line Description := 'Drawing Link'.Work.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: slicing and dicing of an array
Hi I can't see an alternative to using the count() function. The construct will be let a := array let b := slice(a,5,count(a)) Is using -1, -2 as a value for 'end' a documented feature?…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Airtable Convert - Looking For Feedback...
Hi I would start by asking "What is it that you want to build?" For some projects Airtable (or Monday.com, etc) will be an ideal fit. I would class most of these projects as collaborative such as a…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac not responding
Hi Fred I too was very interested in your hyper dashboard. I think you could have got away with calling it your own! Do you have a Trigger on create script to automatically link records to the hyper…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: using formula to update fields or delete records
As well as Mel's suggestion (which will speed things up significantly change the first line to for a in Student where high = 1 do These are all fixes but the main problem is that I don't think your…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: add field by script
Hi It looks like this should work. Where and how are you running this script? Are you creating a child record from a parent? If so the child is being created but the link to the parent is missing and…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 31

Back to top

Ninox-Documentation

Overview

View all topics