How to enable Javascript

Latest Posts

Re: formula greater and less Don't for get to make one them equal to 2000, 4000 or 7000. An exact match of these values won't evaluate to anything.
- John Halls
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Formula fields show no data in table view I see that the second line of your code says if sum(Prestaties.Laden) >= 0.25 and sum(Prestaties.Lossen) >= 0.25 then and I wonder if it should say if 'Laden werf 1' >= 0.25 and 'Lossen werf 1' >= 0.…
- John Halls
- John_Halls
- 3 wk ago
- Get help
- Reported - view
Re: Make graph based on specific records Hi You could add a Yes/No field to your table to indicate if this is to be included in your graph. It could be just a field that you set at the time of taking the reading,…
- John Halls
- John_Halls
- 3 wk ago
- Get help
- Reported - view
Re: Formula fields show no data in table view Hi Can you share with us the formula that you are using? Does it include a select command by any chance, as these don't update automatically? Regards John
- John Halls
- John_Halls
- 3 wk ago
- Get help
- Reported - view
Re: Hide Multiple fields at once @Kent Signorini Hi Kent When you go to 'Edit fields' the tabs are listed along with the fields. Click on the one you want to hide, then under 'More options' is where you will find 'Display fields…
- John Halls
- John_Halls
- 4 mths ago
- Get help
- Reported - view
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
- John_Halls
- 4 mths 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
- John_Halls
- 4 mths 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
- John_Halls
- 5 mths 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
- John_Halls
- 5 mths 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
- John_Halls
- 5 mths 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
- John_Halls
- 5 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths ago
- Learn & 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 6 mths 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
- John_Halls
- 7 mths 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
- John_Halls
- 7 mths ago
- 1reply
- 28
- 3
- Learn & 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
- John_Halls
- 7 mths 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
- John_Halls
- 7 mths 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
- John_Halls
- 7 mths ago
- 1
- Learn & 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
- John_Halls
- 7 mths ago
- Get help
- Reported - view

1 2 3 4 5 21 Next

John Halls

John_Halls

Somerset, England

511
51
1

Joined: 11 Feb 2021

Follow