How to enable Javascript

Latest Posts

Re: Select statement in formula is REALLy slowing my table down. Any solution? Thanks Sean!
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Select statement in formula is REALLy slowing my table down. Any solution?
I have a table with a formula field, that requires a fairly heavy "select" statement. Problem is that the "select" statement is common to all records in the table (there is not variable within the…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 2replies
- 1,084
- Get help
Re: today() function giving yesterday's date Using the console is working for me, too. BUT, in my table, I have a "Trigger on Create" script that is doing: 'Record Added' := today() This is what fails for me.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: today() function giving yesterday's date Ninox Cloud. Found a previous post suggesting it that it may be related to server side settings (maybe even down to the server clock being incorrect).
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
today() function giving yesterday's date
Today I've been having two big issues with date functions in Ninox: 1 - If I use the today() function, it returns yesterday's date. 2 - I am trying to compare two dates within an if statement.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 6replies
- 1,708
- Get help
Pie chart for a single record
I want to display a pie chart within a form, that visualises info contained in numeric fields within a single record of a single table. But it seems no matter how I try to construct the forumla for…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 3replies
- 799
- 1
- Get help
- Answered
- Answered
Combo chart (bar chart with target line)
I'm wanting to display a bar chart within a form, which includes a dotted "Target" line, a bit like this: Is this sort of thing possible in Ninox? I'm on Ninox Cloud.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 1reply
- 873
- Get help
Copy to system clipboard?
I'm using Ninox Cloud, and want to create a button that copys a block of text to the system clipboard. Is there a function to copy to the system clipboard, or is this not possible?
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 1reply
- 1,087
- Get help
Re: Justify Form Elements with common top line Yes, that's the issue I have. The View is hugely variable, so any attempt to set the formula height just fails when I move to the next record.
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Justify Form Elements with common top line
I'm trying to layout a form with multiple different types of elements in a row. For instance I have a formula field, and to the right of it a View into another table.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 2replies
- 1,182
- Get help
Re: Sort related records by specific field Great. Thanks! I'll give it a go.
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: html style not working Ha ha! Thanks Sean.
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: html style not working ARGH! Was escaping the double-quote marks incorrectly. Should be "" instead of """". Was mixing up my languages. My bad :-(
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
html style not working
I'm trying to use the "html()" function inside a formula to try and style some text fields. Here's an example of what I've tried: html("<h1 style=""""color:blue;font-size:86px;…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 4replies
- 1,506
- Get help
Re: Sort related records by specific field Hi Sean. Can you clarify that? What I guess you're saying is that as long as the main view of that form is sorted by "SV Number", any array of records generated by a formula in a related table would…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field It should do. The database is tracking Visual Effects production for TV. The "Submission Clips" table which I'm querying holds records of a huge number of video clips being sent to us for review.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field Ah. That's frustrating. Am I right when I'm seeing that "Select" is a lot slower than using the record relationships to populate a view or make calculations?
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Sort related records by specific field
I have added a new formula field to a table. The forumla needs to get related records from another table, sort those records based on a specific numeric field,…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 8replies
- 2,412
- Get help
Re: A few questions about form layout Thanks Steven. Might try the Formula with "On Click" event as a workaround. Peter, it seems the ability to hide a label isn't available on Views, which makes things tricky.
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Re: A few questions about form layout Thanks Mel. I guess there's no easy solution right now, but thanks for the answer. :-)
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
A few questions about form layout
One of my biggest hurdles with Ninox forms has been setting up the style and layout I want. Hoping people can help with these specifics: - When i put a View element on a form,…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 7replies
- 1,424
- Get help
Re: Script to set reference field to empty Oh! I didnt' even think of that. Will try.
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- Get help
- Reported - view
Script to set reference field to empty
I have a script that attempts to set link a child record to a parent table based on an expression. If the child record doesn't meet the crieteria, it sets the link to "empty".…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 3replies
- 1,087
- Get help
When to enabled "Index" on a field in a table?
Is there any rough guide or rule of thumb for when it is helpful to enable the "index" for a field in a table? My database includes a lot of calculations with select statements,…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 787
- Get help
Populate dropdown with options from linked table
I have two tables linked with in a 1:1 relationship. In a form for Table A, I want to put a dropdown or similar selection field in which a user can select which record they want to link from Table B.…
- Peter Amies
- Post Hoc Limited
- Peter_Amies
- 2 yrs ago
- 1reply
- 1,133
- Get help

1 2 Next

Peter Amies

Peter_Amies

Post Hoc Limited

36
1
0

Joined: 06 Jan 2020

Follow