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 show all fields at once?
@Jack said: However, our business operations and use of databases are not typical. I am intrigued. Can you tell me more?
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to show all fields at once?
Hi Jack I'm with Fred on this and nearly wrote as such as soon as you posted. You can't expect to be able to take in all 100 fields at a time. I wonder, with 100 fields,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Count number of fields containing zero
Hi Chris Whenever you have fields like this, it's a sign that the set-up is incorrect. Your multiple fields should be records in a sub-table. Once re-configured tasks like the one you are asking for…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Summary table of multiple tables
Hi Jack I would look at your sub-tables and consider if they can all be put into one sub-table. It sounds like they can from your description. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: automatic numbering using any number column.
Hi Chris Is this a number or a text field? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Choice field: There can be only one!
Where you have a 1:n relationship for all the sub-table entries, I would have a second relationship but the other way round n:1, just for the active record.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Sub-Tables - Add existing record
Hi Paul I had a feeling that 'Add existing record' didn't show if composition is set to Yes, because in theory there shouldn't be any orphan child records to add.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Update Reference field from Text Field
According to your data model screenshot, Customer should be Customers let t := this; Customer := first(select Customers['Company Name' = t.'Serviced Customer']) Regards John
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR You have surpassed yourself here. Massive congratulations on this.
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Sending emails reminders automatically in Enterprise version
Hi Javier I have used Zapier to do this. Here is a previous post giving step-by-step instructions https://forum.ninox.com/t/x2hbzyb/timed-scripts Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Can't see records, while they can be searched and found...
@Bas Jansen As @RoSoft_Steven mentioned, can you post your database so we can have a look at it. Not sure having two tables with the same data is a good idea,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Parent / Child / Grandchild
My understanding is that you cannot print views. You would need to run a script to directly relate the grandchildren to their grandparent and then you would be able to print them.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
Hi Sam Does your code work? If these are linked you don't need the select statement. I don't understand the two pairs of square brackets. Is Customer a field? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
If the child is Orders and the parent Customers, a table view of Orders can be filtered to only show true records of this formula Id = first(Customers.Orders) Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
Try changing the select to select Clients where Status = 3 and ('Termination Reason' = 1 or 'Termination Reason' = 4 or 'Termination Reason'= 6) and similarly with the second select statement Regards…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Fred milestone - 1,000 posts!

@Fred I've just seen you have recently achieved that amazing milestone of having posted over 1,000 times. Congratulations and a massive thank you from all of us in the Ninox community.
- John_Halls
- 2 yrs ago
- 1reply
- 51
- 3
- Learn and share
Re: how to lock a cell at a given value?
Hi Alain Transactional data, like quotes, orders and invoices should not change over time so I would have a price field in the estimate line and this is populated from the current price in the stock…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Running total every 5 days
You could try this let d := Date; sum((select Table1)[Date >= d - 7 and Date <= d and weekday(Date) < 5].Number) Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Running a script for each record in a subtable...
Further to @Fred , if it's a block of code you need to run use a for loop for a in ReferenceFieldName do <<Code Block>> end Any reference to a field in ReferenceFieldName is prefixed with an a plus a…
- John_Halls
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Making a single reservation, blocking all other requests
Hi I would set up a relationship that allows for many offers for a reservation, and a second relationship that is the other way round so that only one offer can block the reservation.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Body of Email field
@david You can see that everything inside the curly brackets is being evaluated, and everything outside is being treated literally. By way of an example,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
@Paul Chappell Hi Paul. How did you find that one out? Counter-intuitive to set a date with a 0 or 13 as the month, yet so useful.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
A mathematical alternative... let t := today(); let d := day(t); let m := (12 + month(t) - 1) % 12; let y := year(t) - floor(m / 12); date(y,m,d)
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
@Fred Yup, bound to happen at some stage. Happy Ninoxing Fred!
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Get Previous Month
@Fred Ah yes, he might not be looking for the date...
- John_Halls
- 2 yrs ago
- Get help
- Reported - view

1 9 10 11 12 13 31

Back to top

Ninox-Documentation

Overview

View all topics