Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

631
86
1

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

My Posts

Latest Posts

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
- 2 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
- 2 yrs ago
- Learn & 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
- 2 yrs ago
- Learn & Share
- Reported - view
Re: NEW FORUM
Fantastic news. Thank you so much NINOX.
- John_Halls
- 2 yrs ago
- Learn & 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
- 2 yrs ago
- Get help
- Reported - view
Re: Show all records in another record that are related by an ID
Hi svs It's not SQL although some of the syntax looks similar. Square Brackets can be used where ever you want to scope a select statement or a relationship.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Please help with selecting last 6 records using internal id
Hi Andrew I would use the function slice instead to select the last 6 records https://docs.ninox.com/en/script/functions/slice let a := select Table1;let b := count(a);let c := slice(a,b-6,b);…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Linking Tables
Well done Alain for a clear explaination of how relationships work in Ninox; it's a hard one to get across. Such a shame these excellent posts can't be 'pinned' to the top of a list for future new…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Problem of links between two tables
Hi If you can say "There can be more than one musician in a band" and "A musician can play in more than one band" then you have a many to many relationship between musicians and bands.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Hi Davie Essentailly what you have here Year Code 2000 AA 2001 AB 2003 AC Is a conversion from base 10 to base 26 but offset by some years. Your AA is the equivalent of the 00 part of 100 so we will…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie If you want to add the same tasks to each page you can automate this. Use either a template table or a flag in your Tasks table to show they are going to be used as a template and use some…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie Yes it's a bit confusing at first. Here's a screenshot of the Pages table. The arrow going the right points to the Folders table and there will be just one for each Page,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie I wouldstart with three tables Folders Pages Tasks Folders can have many pages so there is a 1 to many relationship between these two Pages can have many tasks so there is a 1 to many…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger after change
As I thought Bobo, a change in the valuse of a formula field will not, on its own, act as a trigger. See my first reply. You will probably need a Trigger after update:…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: INVENTORY
Good luck! Any questions just ask.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: INVENTORY
Hi Jean-Philippe I posted a reply to a similar query a while ago. You may be able to adapt it to suit your needs.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo Are either of 'Orders available today' or AmazStars formula fields, calculated from fields in another table? Thanks John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Stuck on simple multiple if/else
Hi Robert Just a couple of tweaks. To use the text of a choice field in a formula you need to use text(Rating) and then as it's in a formula field just use the value without the equals sign.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo If the total is a formula field calculated from the sum of child records then it won't trigger if your Trigger after update: is on the parent. It has to be on the child,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Query - Vieuw
Hi Michel How many records do you have in each of the tables Contractor, Gebruiker and Registraties_Detail? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
Hi John The 1.5 trick gives it a temporary sort order value between the one above and the one above that, before all being re-assigned a new order value.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Merry Christmas to all my Fellow Ninox Forum Users
Merry Christmas one and all. I am looking forward to chatting to you all again in 2022. Happy dolidays! All the best - John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
It should, of course, be if insure = "yes" and value > 500 then "Yes" else "No" end Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
Hi Davie You are correct, create a new formula field with a formula something like this if insure = "yes" and value < 500 then "Yes" else "No" end Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Sort day field alphabetically, I want Monday, Tuesday, Wednesday...
Hi Mr K I encountered the same problem. I ended up prefixing my days with a number: 1-Monday, 2-Tuesday, etc Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view

1 12 13 14 15 16 26

Back to top

Ninox-Documentation

Overview

View all topics