-
Dynamic Choice Field Assistance
I am having some trouble with a dynamic field: let ths := this; let thisUserDepartment := ths.Department.Id; let thisUserTitle := ths.'Job Title'.Id; (select 'WFM Permissions' where numbers('Eligible…
- Answered
-
Copy contents of reference link to another field.
Hello. The "Select" field you see in the screenshot is a "Link to" reference. My intention is that whatever is selected, should be copied over to the "Description" field (text field).…
- Answered
-
Current Storage Capacity
Hello and congratulations on this FANTASTIC, USER FRIENDLY database. I checked one of my records this morning and realise that it was missing its attachments.…
- Answered
-
Parameters it is possible to pass to a function
Hi, fairly new to Ninox and now in the process of "tidying" up a database which has become a bit untidy in terms of number of fields and duplication, this thread sort of fits with what I am trying to…
- Answered
-
Hide Multiple fields at once
Hi, I know we can hide individual fields by going to Display field only, if & entering "null". I have say 10 fields that I want to hide. For that to happen,…
- Answered
-
Minimum value 'number'
if not 'Number 1' then 'Number 1' := 'Number 4'; Formula gives value for 'number 4', after that I have the opportunity to change it if necessary. But I can't give it a value 0,…
- 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
-
Timer for delete record
there is a table where a lot of records are collected during the day. After 10 days, they are no longer relevant, and i need to delete them if there is no comment and claim from the buyer.…
- Answered
-
Share information between two tables
Hello I have a formula that copies information from another table when the table name is same let t := this; first((select AllTables)['Table Name' = t.'Table Name'].…
- Answered
-
Import csv files with related tables.
How's it going. I need a procedure to import csv files with related tables. There is something hidden somewhere.
- Answered
-
15 Minute webinar
Who can give a link to a 15 minute webinar? old link write that it is not available Regards
- 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
-
Next Item in Line Formula
I am creating an approval flow in Ninox. I have a field named 'Current Step' and a list of that displays the order of the steps. Named 'Step Order' and the value is '1,2,…
- Answered
-
Multiply for formula fields
Hi The table has formula fields "Formula 1" and "Formula 2", which, for their part, take information from other tables. I need to multiply "Formula 1" by "Formula 2".…
- Answered
-
Getting number from table
Hello and thank you in advance My Database has tables called Unit Rentals 1 Unit Rentals 2 Unit Rentals 3 i can't extract the number from a table like you can using a substring in a field any advice…
- Answered
-
Use Tooltip to echo contents of a field.
Probably for the JS/HTML/CSS geniuses @Jacques TUR :-). I have formula field which fetches a note field contents from another table. Because I have to keep the formula field as small as possible the…
- Answered
-
Accumulated by Staff Problem
I have a Problem on Accumulated by Staff fórmula. Example Marianela have 110 hours (104 normal + 6 overtime) but only sum 104 on the Accumulated by Staff. Some help
- Answered
-
ANOTACION EN PDF
Hola, soy nuevo y poco a poco voy creando mi base de control de obras, he visto que la nueva actualización incluye PREVISUALIZACION Y ANOTACIONES EN PDF,…
- Answered
-
Running number issue
Hello everyone. I've setup running numbers for our stock, invoices etc. That does work as intended. However, if any previous record is deleted, the next number created will be a duplicate.…
- Answered
-
Filter an array based on a Multichoice using another Multichoice
So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…
- Answered
-
Locale backup has no data
Hello, when I download a backup and click on import archive locally on my Mac Ninox Database App, the locale backup has no data. Everything else seems to work, but the tables are all empty.
- Answered
-
Show form of combined select (or array) logic
Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…
- Answered
-
Show value of line items depending on the choice field selection
Hello everyone. I have created a formula field to show the current total of our Petty Cash which is in a subtable. This needs to exclude amounts which were transferred to/from a bank.…
- Answered
-
Adding and removing items from a list
Hi From the list myPersona I have to delete names that I find in the list myEsclusi and add names that I find in the list myAggiunti. Can you please help me.
- Answered
-
Count number of fields containing zero
In a table, I have 14 fields (this week, this week - 1, this week -2, this week -3, and so on, until I have the total miles in a field from 13 weeks ago),…
- Answered
Answer questions and share your knowledge