John Halls

John_Halls

Somerset, England

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: Speed issue
Hi Frits Select statements can become a bit slow with large sets of data. From the example you have given I don't think this can be totally replaced by linking the tables,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Timed scripts

I've been testing out Zapier as a hack for timed scripts, with success. A Zap has a trigger and an action, and I created one along these lines In Ninox,…
- John_Halls
- updated 3 yrs ago
- 3replies
- 464
- 4
- Learn and share
Re: Updating the appointment Field after inputing the date
Hi Admin Ninox doesn't have timed scripts (yet?). The best place to put something like that would be the Trigger after open. You could create a script that looks to see if the appointments have…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Put Value Number after Formula
Hi Rafael Not quite sure why this isn't working. It's odd how it's adding 9 and 10 together. Put this in a view so that you can see which records are being added together.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Put Value Number after Formula
Hi Rafael As I understand it, you have a field for each week. Could you let me have a copy of the formula you are using for Semena 9, and also for Semena 10. Thanks, John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Put Value Number after Formula
Hi Rafael Could you explain this part for me. @Rafael Sanchis said: Example for week 9 place 144 is ok but for week 10 sum the 9 and 10 366 and week 9 place 0
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Put Value Number after Formula
Check out the functions week(date), yearweek(date) and today(). let x := (select Documentos where Semana = week(today())); sum(x.'Horas Ganadas Plan') Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Not equal sign
Hi Simon Not equal is != Checkboxes use the 'Yes / No' field type. If we have one called Checkbox then Checkbox Results in "Yes" or "No" number( Checkbox ) Results in 1 or 0 But you don't need to…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Look up value in table based on two other values
Hi Alex In your main table have Density and Temp numeric fields and a formula field for ABV with a Lookup table with numeric fields for Density, Temp and ABV populated with your lookup data.…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Set Choice Value
Hi I don't think there is a function to give a list of choices available for a choice field, and then find the id based on its text value. I would think this is because choice fields are designed to…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to Reverse Linking between 2 tables ?
Yes, Fred is right. I didn't explain my reply very well. My Table2One is a new reference field. Once updated the Table2Many reference field can be deleted if you are sure it has worked correctly.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to Reverse Linking between 2 tables ?
Hi Julien The answer is yes, but only if you have, as you mention, a one to one relationship between your tables for a in select Table1 do a.(Table2One := first(a.Table2Many)) end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Convert table to subtable
Hi GB This is called Normalisation where A is a flat file that has repeating fields that you would like taken out of A and put into B. It reduces redundancy, and makes for a more manageable system.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Other formula problem
My pleasure!
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
Hi Fred I spent an evening trying to find a solution to this and, as Alain and yourself have concluded, there is no solution. All I could suggest is to run a script from a button in one of two ways…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Other formula problem
Hi Rafael This works sum((select Disciplinas)[Disciplina = "Civil"].Actividades.Documentos.'Horas Ganadas Plan') This is complex because you are looking for totals on the Documentos table,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Other formula problem
Is the document table any of Actividades, Disciplinas or Discilina? Or is it another table altogether? If so is it linked to any of the other three?
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Message - Improvement
I was thinking this sort of thing in the Trigger after open: let a := first(select Global); if a.LastOpened < today() then "Send email Script Here"; a.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Other formula problem
Hi Rafael If 'Horas Ganadas Plan' is a field in Actividades the you should be able to do this in one line, something like sum(Actividades[Disciplinas.Discilina = "Civil"].…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Message - Improvement
Hi Mel As Stephen says, use a flag. I use a table that only has one record. The fields are then used as global variables, so add a date field which can be tested prior to sending your daily email,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
I'm wondering if you need to bracket the boolean logic select Jobs where Stato = 2 and 'Stato lavorazione FOTO' = 4 and ( 'Stato Album' = 1 or 'Stato Album' = 3 or 'Stato Album' = 4 ) and I don't…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Sticky Messages or Tags
Thanks Yes, just tried the block code @Fred , very good. Give me a few days and I'll come back with the beginnings of a FAQ list.
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: Sticky Messages or Tags
Great idea Mel. How about 'FAQ' or 'Pinned' or 'Sticky'. I am sure we can come up with some common questions and then divvy them up between us to offer some standard answers that users can easily…
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: NEW FORUM
Fantastic news. Thank you so much NINOX.
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters
Hi Borgir! Yes, this can be achieved with a script, either one record at a time or en-mass. You need to decide which of X and Y is going to act as the parent.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 33

Welcome to the Ninox community

John Halls

My Posts

Re: Speed issue

Re: Updating the appointment Field after inputing the date

Re: Put Value Number after Formula

Re: Put Value Number after Formula

Re: Put Value Number after Formula

Re: Put Value Number after Formula

Re: Not equal sign

Re: Look up value in table based on two other values

Re: Set Choice Value

Re: How to Reverse Linking between 2 tables ?

Re: How to Reverse Linking between 2 tables ?

Re: Convert table to subtable

Re: Other formula problem

Re: Pass current viewing record Id to a view element column formula

Re: Other formula problem

Re: Other formula problem

Re: Message - Improvement

Re: Other formula problem

Re: Message - Improvement

Re: Syntax stupid question

Re: Sticky Messages or Tags

Re: Sticky Messages or Tags

Re: NEW FORUM

Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters

Overview