Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

758
128
1

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

My Posts

Latest Posts

Re: Unique Field in a table
Hi Javier @Javier said: This way the client needs to enter only one time the customer information, and also has a way to search for the client in the database,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula don't give anything
Hi Rafael This line will never be true if Week = (select Documentos).Semana then Because Week is a number (or text) and (select Documentos).Semana returns an array,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Ninox Developing Service
@Andreas I'd be interested to know how you get on.
- John_Halls
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Production: should storage tanks share a table or each have their own?
@Alex Mumm Great, well done Alex. Any problems, just ask.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Need help with very simple for loop
Hi corey There's no need for a loop. You need to know how many 8.5's there are in the total time. For the example you gave 27.5/8.5 = 3.24 but you just need the whole number part of this, ie 3.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Production: should storage tanks share a table or each have their own?
Hi Alex No, your tanks need to be records in a single table. I would have three tables, Bins to hold the tanks and production areas (distillations?), Transfers to hold each transfer and Inventory to…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Button in table x (subscription) to create a record in table y (Deliveries) and its subtable y2 (Delivery lines)
Hi Heikel This might not be as you have your system set up, but it might help If your subscriptions are set up as follows Customers --< Subscriptions --< SubscriptionLines >-- Products and your…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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 2 yrs ago
- 3replies
- 427
- 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: Other formula problem
My pleasure!
- John_Halls
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view

1 16 17 18 19 20 31

Back to top

Ninox-Documentation

Overview

View all topics