Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Paul Chappell
Paul_Chappell
82
18
0
Joined: 14 Apr 2022
Follow
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Paul_Chappell
1 yr ago
Get help
Reported - view
1
2
3
4
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics