-
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,…
- Answered
-
Leave formula field empty if .....
Hello. In our quotes, we often have to write some details within line items. But in the printed quote, it show "0.00" next to it. Qty and PPU (Price per Unit) are number fields.…
- Answered
-
Sort / Order by based on total count
That is even hard to explain. So I do use a dynamic choice box do suggest possible values based on already existing values from that column. I can sort them alphabetically but I would love it if,…
- Answered
-
Auto enter current date when a field is updated?
Hello, I am wondering if there's a way to have a date field self populate with the current date whenever I make changes in a field. I have a database with a 'Notes' section,…
- Answered
-
Closing account
Hello, I've started a free trial, but that works only online and it's not what I'm looking for I'd like to cancel the account I have created. Instead, if I buy the version "on premise",…
- Answered
-
Check if 7 fields have been filled
Hi! In a table there are 7 fields to fill and 1 button. The button serves to create a record in a linked table, on this I have no problems. I would like the button script first to verify that all 7…
- Answered
-
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Answered
-
calendar option missing
I have Ninox Mac version 3.10.10 and my system is MacOS Sonoma 14.2. I have a MacBook Pro 2020. I unistalled Ninox from my iPad and iPhone, I have been working with this 3 devices and I have data…
- Answered
-
Parent / Child / Grandchild
Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…
- Answered
-
Syntax stupid question
Hi, for sure will be a stupid thing but I can't figure out where I'm wrong in the syntax of this formula. Can anyone help me please? Thanks
- Answered
-
Automatic table cleaning after one year
in my database there is a table that collects information about discounts. But they are valid only for a year. How to make sure that all information in the table is deleted after a some time,…
- Answered
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
conditional unique() in column
my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…
- Answered
-
Please teach me how to use this global function :-)
This code can be used in global functions and I want to make use of it. I know I can call it from a Form/Tab as needed but how? "--- This controls the HUD icons top right ---";…
- Answered
-
Automated Multiple Choice: Is it possible?
Is it possible to automate Multiple Choice field based on trigger/update from another fields – which is two or more fields. See situation below: Multiple Choice (MC):…
- Answered
-
Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- Answered
-
Order by date from text field
Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that?…
- Answered
-
How to auto create new record every day?
I have to create a daily record, but I have to hit the button every time. Now I want to use loop function to create new record every day. can someone show me how please?
- Answered
-
Open view on startup
Is there a way when the Database is opened (OnPrem) to go to a view so it’s always what the user sees when they start?
- Answered
-
How to get a dynamic multi choice field to update
Hi all - I'm using the MacOS app. So I have this code in the Dynamic value section of a field called dMC2: let prevDMC := numbers(dMC); (select Table1)[(var t := this;…
- Answered
-
Button script to select/link record on child table
Using the Invoice Template, I have a the 'Invoice' Table with an embeded 'Invoice Items' table. I add items to 'Invoice Items' by selecting existing records previously input in the 'Article' table.…
- Answered
-
Update multiple records
I seem to have lost the ability to update multiple records. Can anyone confirm this for me and if you still can - how?
- Answered
-
Formula ID count also deleted records
Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…
- Answered
-
Return to my Topic
@Fred @RoSoft_Steven Rooryck To Return the topic since it point that I need to have my DB at last 90% . Excuse the insistence but is very important and I can't resolve this.…
- Answered
-
Select a field in a record in a linked table on Trigger new data set
Hi! I have 2 linked tables: TAB-A and TAB-B In TAB-B I have a number field named "nr" In TAB-A I have a number field called "tax" In TAB-A I have this formula in Trigger in new data set: let dtsel :…
- Answered
Answer questions and share your knowledge