Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
2
replies
1,091
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
6
replies
1,757
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
3
replies
851
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
1
reply
884
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
1
reply
1,105
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
2
replies
1,188
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
4
replies
1,521
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
8
replies
2,454
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
7
replies
1,435
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
3
replies
1,122
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
3 yrs ago
791
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
3 yrs ago
1
reply
1,147
Get help
1
2
Next
Peter Amies
Peter_Amies
Post Hoc Limited
36
1
0
Joined: 06 Jan 2020
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags