Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
1
reply
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
Home
Learn & Share
Get help
Webinars
View all topics
Tags