Skip to main content

Ninox-Documentation

Paul Chappell

Paul_Chappell

87
19
0

Joined: 14 Apr 2022

My Posts

Latest Posts

Home Button Hidden

One of my workspaces has a sidebar where the Home Button is hidden to users. In edit mode I can access the Home Button menu and hide Search, Calendar or the whole Sidebar, but not the Home Button.…
- Paul_Chappell
- 2 mths ago
- 26
- Get help
Sidebar Home Button is hidden

One of my workspaces has a sidebar where the Home Button is hidden to users. In edit mode I can access the Home Button menu and hide Search, Calendar or the whole Sidebar, but not the Home Button.…
- Paul_Chappell
- 2 mths ago
- 31
- Learn & Share
Re: Ninox 3.13 available
Is it just me or has the date format changed from DD/MM/YYYY to MM/DD/YYYY?
- Paul_Chappell
- 3 mths ago
- 1
- Learn & Share
- Reported - view
Re: ninoxLocales.AggregationName is not a function
I have narrowed the issue down to the "do as server" command so it looks like an issue with the Ninox servers. Hopefully Ninox will sort it.
- Paul_Chappell
- 4 mths ago
- Get help
- Reported - view
Re: ninoxLocales.AggregationName is not a function
I have the same error this morning. Nothing has changed. Must be a Ninox issue.
- Paul_Chappell
- 4 mths ago
- Get help
- Reported - view
Re: Getting number from table
@Roger Buckley I don't think there is a way of manipulating a table name. But why not just still simply have a field in each table called "Unit Number"? Fill it with the number of the table,…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: gantt as pdf
You can create a Gantt View of any table and then share it out to anyone as HTML or PDF.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Getting number from table
@Roger Buckley Hi Roger. Ok. So you have 70 rental units. And presumably each unit will have similar fields - Size, Colour, Date Arrived, etc. You have created a separate table for each Unit.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Getting number from table
So. You have 3 tables. What fields do you have? What are you trying to achieve with those fields? We need more information to go on.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Search in formula field
You can search a formula if that field is included as a column on the main table view, but not with the global search.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Is it possible to split the Location field to several address formula fields in Ninox?
@Jan Inge Iversen Split the line that contains the city and code using a space. Assuming it is always the same line. If it's not always the same line then you can't unless you split every line and…
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
@Gianluca Yes. The idea of my example is first you create the names. Then you create a Contract from either the Name record (which automatically links a new Contract to the Name record) or from a new…
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Is it possible to split the Location field to several address formula fields in Ninox?
Yes. This should put you on the right track. You just need to split the Location field into an array. To show how this works create a formula field and expand it over several lines.…
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
@Gianluca That's fine. Just add the button to the Names table and loop through each contract. New sample attached..
Attachment
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
@Gianluca Sure. You just need a sub-table.. see revised database attached. With all of this you cannot create records where "endDate is today" because "today" is constantly changing.
Attachment
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
@Gianluca No problem. You don't need to worry about the "do as server" and having 2 buttons. Ninox will handle it automatically.
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
@Gianluca The idea is to loop through the years past and future to find overlapping dates in order to create the academic year records. "do as server" tells Ninox to create the records on the Ninox…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Switch with multiple for loops and consequents new records
Quite straight forward. See attached sample database with code to generate records.
Attachment
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Summary table of multiple tables
I would suggest the structure of your database is wrong. You probably only need 2 tables: one for the Holiday itself containing the main details, and one for the Elements.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Run a script to Form open or Form Close
@Mel Charles I'd need more information about what you are trying to do, but the Tab triggers combined with the Table "Trigger after update" script should allow you to run script when any tab is…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Run a script to Form open or Form Close
On a Tab you have "Trigger before view" and "Trigger after hide" scripts that allow you to do certain things before and after a tab is shown. You could use this to control if a user has to start on a…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Button to validate required fields
This is a consequence of the way Ninox is designed. Fields can be marked as "Required" but there is no way of using that information in a trigger, as far as I know.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Impossible to add a new recording…
Not really without something more to go on. Such as: Which platform are you using? Do you tables have access to create records? Have you tried refreshing the records view?…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Cut & Paste a screenshot.
Well, yes. Sort of. Using a Rich Text field. Do a screen grab using whatever method for your particular platform, and then just copy and paste into the field.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Reference to items in the same table
@Fred @vincent. cattersel Yes. In any case, no-one wants to scroll through (or choose from) 450 items in a list. It would probably be better to structure your table to allow the items to be…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view

1 2 3 4

Back to top

Ninox-Documentation

Overview

View all topics