How to enable Javascript

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
- 3 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
- 3 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
- 3 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 mths ago
- 5replies
- 87
- 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
- 4 mths ago
- 10replies
- 170
- 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
- 4 mths ago
- 28
- 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
- 4 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
- 5 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
- 5 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
- 5 mths ago
- 2replies
- 56
- 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
- 5 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
- 6 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
- 6 mths ago
- 4replies
- 33
- 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
- 6 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
- 6 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
- 6 mths ago
- 7replies
- 82
- 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
- 6 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
- 6 mths ago
- 3replies
- 117
- Get help
- Answered
- Answered

Alex Mumm

Alex_Mumm

24
0
0

Joined: 14 Mar 2022

Follow