John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: using formula to update fields or delete records
Hi Dariel Add a number field called high to your sub-table. Add a button with this code for a in Student do a.(high := 0)end;for b in unique((select Student).…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: What is the syntax for operations between fields in different tables?
Hi Zenmom When both fields are in the same table tboth values will come from the same record. When they come from different tables you need to be able to say which records they come from.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
That's great Mel slice gives you a subset of an array slice(array, start, end) Arrays start counting from 0 ( so 0 is the first element of the array) and the start is inclusive but I think end is…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: How do I copy some certain fields when creating an invoice?
Hi Art In your code your let statements are creating variables, not updating fields. Using Fred's example, your code becomes let myID := this; let cre := (create Rechnung);cre,Kontakt := myID.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Hi Mel You don't need to add any counter lines. Take your select statement and then scope this to the first 75 lines let a:= select Customers where 'GDPR Status' = 1 and 'Send Email';…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Replicating a value in a different field via a button
Hi Giovani Use this code let a := MasterRecord.SubRecord;X := last(slice(a, 0, count(a) - 1)).X Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Create a Filter given a condition
Hi Kieta If this is in an unrelated table use something like LastDate := last(select table where Status=2 order by date).date If it is a child table use something like this LastDate :…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Replicating a value in a different field via a button
Hi Giovanni Use the Trigger on create: in the SubRecord add this line X:= first(MasterRecord.SubRecord).X For the first SubRecord it will be ignored, and you can add a value to X manually.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: In script is there a way to move a record from one table to another without doing it field by field in the record
Not that I am aware Robert i.Column1 := j.Column1; i.Column2 := j.Column2; ... i.ColumnLast := j.ColumnLast; can be slightly simplified to i.(Column1 := j.Column1; Column2 := j.Column2; ...…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi Mel After a while playing in the console I have found that date > today() works and date < today() works but date = today() does not. I have also found that, as Steven has said,…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
Hi Mel Thank you for such a thorough answer. It's amazing what you have done. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Mel, I have a very expensive ERP system which I would love to dispense with. I always thought I would replace it with FileMaker but I am leaning more and more towards Ninox.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi Mel Not sure why you swapped today() for now(). now()+2 does not add two days to it's value and comparing a date and a timestamp will always return false.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Hi Mel A select will always return an array, unless it is wrapped in an aggregate function, so your if statement would work better like this if cnt(select JobDockets where DispatchBy = today() + 2) >…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 34

Welcome to the Ninox community

John Halls

My Posts

Re: Trigger on Update not triggering

Re: Code help please

Is something odd is going on with the Forum dates

Re: Setting up a FIFO inventory

Re: Copy field contents into another linked tables field

Re: Copy field contents into another linked tables field

Re: slicing and dicing of an array

Re: Airtable Convert - Looking For Feedback...

Re: Ninox for Mac not responding

Re: using formula to update fields or delete records

Re: add field by script

Re: using formula to update fields or delete records

Re: What is the syntax for operations between fields in different tables?

Re: emailing list of contacts not changing the firstname in list

Re: How do I copy some certain fields when creating an invoice?

Re: emailing list of contacts not changing the firstname in list

Re: Replicating a value in a different field via a button

Re: Create a Filter given a condition

Re: Replicating a value in a different field via a button

Re: In script is there a way to move a record from one table to another without doing it field by field in the record

Re: Testing a due date from the Global Trigger after open

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Testing a due date from the Global Trigger after open

Re: Testing a due date from the Global Trigger after open

Overview