Skip to main content

Ninox-Documentation

Alex Mumm

Alex_Mumm

24
1
0

Joined: 14 Mar 2022

My Posts

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
- 11 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: When to use "do as server"?
I should mention that I'm using the web app.
- Alex_Mumm
- 1 yr 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
- 1 yr ago
- 5replies
- 192
- 1
- 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
- 1 yr ago
- 10replies
- 450
- 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
- 1 yr ago
- 48
- 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 2replies
- 80
- 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 4replies
- 59
- 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 7replies
- 110
- 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
- 1 yr 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
- 1 yr ago
- 3replies
- 235
- Get help
- Answered
- Answered

Back to top

Ninox-Documentation

Overview

View all topics