How to enable Javascript

Latest Posts

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 days ago
- 11
- 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 days 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
- 3 wk 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
- 1 mth 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
- 1 mth ago
- 2replies
- 49
- 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 4replies
- 30
- 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
- 2 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
- 2 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
- 2 mths ago
- 3replies
- 40
- 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
- 2 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
- 2 mths ago
- 3replies
- 78
- Get help
- Answered
- Answered

Alex Mumm

Alex_Mumm

13
0
0

Joined: 14 Mar 2022

Follow