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: 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: How to lock dataset/fields with Button?
Hi Deepak If you use the above code, once set you will disable editing for everyone, forever. The only way out will be to hit the spanner ane remove the code.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Striping time from an appointment field.
Hi David Create a formula field to hold your date with this as its formula date(year('Date / Time'),month('Date / Time'),day('Date / Time')) Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Loops syntax
Hi Greg The item() function works with arrays and I don't think Table.Field is an array. I'd answer Stephen's questions, especially what is it you are trying to do? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Formula to calculate the duration in Hours and minutes of a work
Hi Fred's answer is the correct way to go but if you want to stick to a time field use an if stataement to check if your duration is positive or negative and add 24 to the answer if it's negative.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Table relationships, data model
Hi zenmom Yes you can delete the relationship. It is held in a field and so deleting that field will delete the relationship. Unlike FileMaker realtionships aren't automatically populated in Ninox…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: rsort not working
Hi Fred I wanted to understand why your initial code was not working and I have found out why. By concatenating and then splitting you introduced a leading space into each element except the first…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Data type?
Hi Jake No guarantee that your database won't slow down but that won't be caused by your choice of field type. There are forum members here with record sets of over 500,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Print all records in date range.
HI Michael You are right, this topic has come up before. In essence it uses a dashboard. Include start date and end date fields plus a relationship to your invoices tabe.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Accessing a single line item on an invoice
Hi How are you deciding on which line you want to see the total for. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Compare tables
Hi Maisam Do the two tables have the same structure (the same fields)? Is there a field that can be used as a unique key? Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice triggers twice
I am running the web version.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 19 20 21 22 23 31

Back to top

Ninox-Documentation

Overview

View all topics