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: Very slow opening table
@Mel Charles I spoke to support and found a solution. I had too many select statements in the fields shown in the table view columns. They were referencing a data table with 60,…
Alex Mumm
Alex_Mumm
7 mths ago
Get help
Reported - view
Re: When to use "do as server"?
@Fred I did have 45 records, not 9. The text box display the correct numbers when the Do as Server code is removed...
Alex Mumm
Alex_Mumm
7 mths ago
Get help
Reported - view
Re: Production: should storage tanks share a table or each have their own?
@John Halls I found the source of my problem. I had the Create New Records set to Admin only for a couple of tables. That meant that non-admin users couldn't create new records even when using the…
Alex Mumm
Alex_Mumm
7 mths ago
Get help
Reported - view
Re: Very slow opening table
@Mel Charles Thanks Mel. I tried downloading a backup and uploading again to create a copy, but it didn't make a noticeable difference. I don't have any large images,…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: When to use "do as server"?
@Mel Charles You might be right about that, but it does definitely give me unexpected results elsewhere. For example, if I look up the Id of the last record in a table and then create a new record…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: function between two numbers
You probably need nested If statements: if Number < 5 then "Result 1" else if Number > 10 then "Result 3" else "Result 2" end end First it checks if the number is less than 5,…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: Production: should storage tanks share a table or each have their own?
@John Halls I've run into a problem running this code on an old/slow computer. It seems like it's (often, but not always) skipping the section of the code to create the new record.…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: When to use "do as server"?
On closer inspection, one of my buttons doesn't have "do as server" code, but is still failing to create the new record in Bulk Inventory. Again, this problem is only happening on one (old) computer…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: When to use "do as server"?
I should mention that I'm using the web app.
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Very slow opening table
I have a table with many many fields (about 55). The form associated with it performs okay, but opening the table itself takes almost a minute even though there are only 36 records so far.…
Alex Mumm
Alex_Mumm
8 mths ago
5
replies
130
Get help
Answered
Answered
When to use "do as server"?
I've been using "do as server" code in lots of my buttons just to make my forms a bit snappier. Unfortunately I've found that on an older/slower computer for some reason the code isn't executed…
Alex Mumm
Alex_Mumm
8 mths ago
10
replies
296
Get help
Report to print multiple tables
For legal reasons I need to keep backups of my records. I think I need to save PDFs of my tables beyond just using Ninox's backup feature. I've found that I can print what I need by using the Print…
Alex Mumm
Alex_Mumm
8 mths ago
36
Get help
Re: Hide Empty Fields
In the options for the field you'll find "Display field only if". Open that up and type only the name of your field. If the field has content, then it will return True and will display the field,…
Alex Mumm
Alex_Mumm
8 mths ago
Get help
Reported - view
Re: today() function giving yesterday's date
I'm having the same problem, but with the Date function. Any numbers I enter into that function return the previous day. For example, date(2022, 3, 6) gives me March 5th.…
Alex Mumm
Alex_Mumm
9 mths ago
Get help
Reported - view
Re: Avoiding a circular reference
@John Halls Thanks again John! I struggled with this for a while, getting unexpected results, until I finally realized that I had typed "Order <=a" by accident. It's all working now.
Alex Mumm
Alex_Mumm
9 mths ago
Get help
Reported - view
Avoiding a circular reference
Here's a simplified version of a table I'm working on: closingBalance = openingBalance + Adding - Subtracting The problem I'm running into is that the openingBalance of the next month is supposed to…
Alex Mumm
Alex_Mumm
10 mths ago
2
replies
59
Get help
Answered
Answered
Re: Finding the sum of the last entry given specific text in a field
I think I didn't state my problem clearly enough, but I've found a solution: let a := this; let b := unique((select 'Bulk Inventory' where month(Date) = a.Month).…
Alex Mumm
Alex_Mumm
10 mths ago
Get help
Reported - view
Re: Finding the sum of the last entry given specific text in a field
@Lars Unfortunately that doesn't work because there are multiple records for each tank field in this Bulk Inventory table. Here's what I have so far: let a := this; let T1 :…
Alex Mumm
Alex_Mumm
10 mths ago
Get help
Reported - view
Finding the sum of the last entry given specific text in a field
Sorry for the nonsensical title. I have a table called Bulk Inventory: In a formula in a different table, I want to find the sum of the 'Cumulative (Laa)' values for the final entry of a given month…
Alex Mumm
Alex_Mumm
10 mths ago
4
replies
34
Get help
Answered
Answered
Re: Production: should storage tanks share a table or each have their own?
@John Halls Thanks John! It took me almost a day to wrap my head around it, but I got it working in the end.
Alex Mumm
Alex_Mumm
10 mths ago
Get help
Reported - view
Re: Look up value in table based on two other values
Can anyone point me in the direction of any resources on database performance for Ninox? Mostly just curious. I'm not experiencing any performance issues yet.
Alex Mumm
Alex_Mumm
10 mths ago
Get help
Reported - view
Production: should storage tanks share a table or each have their own?
I need some advice regarding the basic logical layout/relationships of my database. I'm tracking production and inventory in a distillery. I have a table for distillations,…
Alex Mumm
Alex_Mumm
10 mths ago
7
replies
86
Get help
Answered
Answered
Re: Look up value in table based on two other values
Thanks John! I got both of your suggestions to work! This is what my actual code looked like in the end: let a := Density; let b := Temperature; DesiredABV :…
Alex Mumm
Alex_Mumm
10 mths ago
Get help
Reported - view
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
Alex Mumm
Alex_Mumm
10 mths ago
3
replies
162
Get help
Answered
Answered
Alex Mumm
Alex_Mumm
24
0
0
Joined: 14 Mar 2022
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags