-
Tables sync
Hello everyone, I have the following problem: I have a Table A with X and Y fields and a Table B with links of X and Y fields. If I choose a value on the link X on Table B then the link to Y field…
- Answered
-
Two Serious Problems... Required Fields & Trigger on new record/update
I just realized there are two serious problems that might be deal-breakers for my business. 1. Required fields don't seem too required. That is to say, I can close a record and it saves (because it…
- Answered
-
Copy Yes/No function value
The table has a button that creates a copy of some records from the table for the next day. Part of the formula looks like this let c := (create 'TABLE'); let t := this; c.(DATE := t.…
- 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
-
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
-
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
-
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
-
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
-
15 Minute webinar
Who can give a link to a 15 minute webinar? old link write that it is not available Regards
- 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
-
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
-
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
-
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
-
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
-
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