Paul Chappell

Paul_Chappell

Joined: Thu Apr 14 07:54:39 UTC 2022

My Posts

Latest Posts

Re: How to improve main menu
Why not have a page with several tabs for set of buttons.
- Paul_Chappell
- 1 mth ago
- Get help
- Reported - view
Re: Class Element Request
Why would you want to remove that? If you remove the edit toggle using code how are you then going to get back into the code to make changes in the future?…
- Paul_Chappell
- 1 mth ago
- Get help
- Reported - view
Re: Issues with 3.15.1
This morning the public server version has reverted to 3.15.0 and everything is working again.
- Paul_Chappell
- 2 mths ago
- Get help
- Reported - view
Issues with 3.15.1

Is something strange happening today? I have issues with Select statements when filtering on dates. Also, on some Views column filtering is not working unless multiple filter options are applied.…
- Paul_Chappell
- 2 mths ago
- 5replies
- 61
- Get help
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
- 7 mths ago
- 28
- 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
- 8 mths ago
- 42
- Learn and 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
- 8 mths ago
- 1
- Learn and 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
- 9 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
- 9 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

1 2 3 4

Welcome to the Ninox community

Paul Chappell

My Posts

Re: How to improve main menu

Re: Class Element Request

Re: Issues with 3.15.1

Issues with 3.15.1

Home Button Hidden

Re: Ninox 3.13 available

Re: ninoxLocales.AggregationName is not a function

Re: ninoxLocales.AggregationName is not a function

Re: Getting number from table

Re: gantt as pdf

Re: Getting number from table

Re: Getting number from table

Re: Search in formula field

Re: Is it possible to split the Location field to several address formula fields in Ninox?

Re: Switch with multiple for loops and consequents new records

Re: Is it possible to split the Location field to several address formula fields in Ninox?

Re: Switch with multiple for loops and consequents new records

Re: Switch with multiple for loops and consequents new records

Re: Switch with multiple for loops and consequents new records

Re: Switch with multiple for loops and consequents new records

Re: Switch with multiple for loops and consequents new records

Re: Summary table of multiple tables

Re: Run a script to Form open or Form Close

Re: Run a script to Form open or Form Close

Overview