Skip to main content

Ninox-Documentation

Paul Chappell

Paul_Chappell

82
18
0

Joined: 14 Apr 2022

My Posts

Latest Posts

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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Reference to items in the same table
@vincent. cattersel Yes. If your table is called Items you just need to say select Items in 'Dynamic value'. Apologies: it should be select and not Select.…
- Paul_Chappell
- 1 yr ago
- Get help
- Reported - view
Re: Reference to items in the same table
@vincent. cattersel It sounds like you need to use a 'Multiple choice (dynamic)' field. In the 'Dynamic value' property of this field type Select Items,…
- Paul_Chappell
- 1 yr ago
- Get help
- Reported - view
Re: Urgent Problem with resize column on Subtables and Views
Yes. It is also a problem with the iPad version. Columns can be resized but only by quickly tapping between the fields and moving very gently.
- Paul_Chappell
- 1 yr ago
- Get help
- Reported - view
Re: Font question
@zenmom There is a simple way to change fonts and styles using html tags, but this only works on formula fields. Example: let result := "This is a test"; html("<style> .…
- Paul_Chappell
- 1 yr ago
- Get help
- Reported - view
Re: Date formats
@zenmom The solution to this sort of problem is to use the month as numbers, but formatted in reverse order: format('date paid [raw]',"YYYY MM DD")
- Paul_Chappell
- 1 yr ago
- Get help
- Reported - view

1 2 3 4

Back to top

Ninox-Documentation

Overview

View all topics