John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Issue with the 'select ... where...' function
You don't need 'Equipe impliquee' twice. Just have let directeurices := count(select 'Equipe impliquee' where 'Type de fonction' = 1) Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
Using a Select statement in a formula field can be problematic. It needs a reason to trigger and so won't be updated in your existing records.
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: count lines of text
Try this let a := YourTextField; let b := " "; let c := split(a,b); count(c) It is putting each line of text into an array (ignoring empty lines) which you can then count. Regards John
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Load (Transfer) Data
Hi Rafael Can you post screen shots of the field structure of the two tables. I want to see what the relationship is between the two. Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
Hi Rafael You are doing everything right, but you are not creating the link, Try something like this do as server let xPry := first(select 'Control Issues'); let xFld0 := xPry.Date; let xFld1 := xPry.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Combining a global variable boolean field with a trigger on table-level
Hi Ruben I've been playing around with this and it looks like Global Fields work as expected in formula fields, and in Buttons, but not in Triggers, which seems like a bug to me.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: maximum user roles
Hi Robbie I built something a year or so ago, just for interest, which had customers and suppliers, with sales orders and purchase orders, but the perspective changed depending on who was the…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Combining a global variable boolean field with a trigger on table-level
Hi Ruben Your Global Field needs to be set at the start of your session, otherwise it will be blank. Either do this via a script or set the default value to Yes or No as required. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 14 15 16 17 18 36

Welcome to the Ninox community

John Halls

Re: Issue with the 'select ... where...' function

Re: Matching Phone Area Codes to Region

Re: count lines of text

Re: Load (Transfer) Data

Re: Load (Transfer) Data

Re: Combining a global variable boolean field with a trigger on table-level

Re: maximum user roles

Re: Combining a global variable boolean field with a trigger on table-level

Re: formula greater and less

Re: Formula fields show no data in table view

Re: Make graph based on specific records

Re: Formula fields show no data in table view

Re: Hide Multiple fields at once

Re: How to show all fields at once?

Re: How to show all fields at once?

Re: Count number of fields containing zero

Re: Summary table of multiple tables

Re: automatic numbering using any number column.

Re: Choice field: There can be only one!

Re: Sub-Tables - Add existing record

Re: Update Reference field from Text Field

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Sending emails reminders automatically in Enterprise version

Re: Can't see records, while they can be searched and found...

Re: Parent / Child / Grandchild

Overview