-
How to create records automatically
Hi! I’m creating a new App calendar deadlines. I have the following tables: 1. Customers a. Name b. Typology c. Accounting Customers are divided into 10 different types and can have 2 different types…
- Answered
-
Help with wedding base
I am starting this new chat as the other one got long and i now have made a sample database and have a lot of info to better understand what i am trying to do. Here is the info.…
- Answered
-
Calling an image from another table
So, I am probably missing something very simple or having a complete brain fade!! In my 'JobDockets' table, I have a button for sending out a goods dispatched email - which works great and also adds…
- 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
-
I cannot edit a database in Ninox Mac app
Hi, I have purchased the Ninox Mac app. While I can edit a database (stored in iCloud) on my Mac desktop at home, I cannot make any changes to fields/... while working on my Macbook.…
- 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
-
Paste Excel cell intor RTF field with simple HTML
Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…
- 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
-
sum((select......... with two values
Hi, I try to use this formula but don't work sum((select Line).Plan_Earned_Act_E; Plan_Earned_Act_P) or sum((select Line).Plan_Earned_Act_E + Plan_Earned_Act_P)
- Answered
-
Are there Trigger limitations?
I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…
- Answered
-
Re-Creating invoices from the Line table
Hi All, I would appreciate some suggestions on how I could re-create invoices from a table of lines. Preferably creating one invoice at a time from the Line table.…
- Answered
-
Load (Transfer) Data
There are any way to Load (transfer) data for one table, to a Reference 1:N on other table, with a Button.
- Answered
-
Converting a text string to a multiple choice field
Hello! I've been having trouble figuring this out and I would love some help. I have a work flow that involves a potential guest (school groups visiting our site) filling out a form that…
- Answered
-
Filter on hidden columns
Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…
- Answered
-
Double Search
I have a double search formula ( Name & Format) let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray :…
- Answered
-
CONSTRAINT
@Fred Hi I need the Constraint for Activities_ Line to Product_Line. I can't find how, I need select only the Line for select it Activities_ Line and no View all.…
- Answered
-
Duration chart
Hi ! Is it possible to calculate a duration to display it on a graph? I would like to have a graph that displays the time worked each month. This calculation is based on the "Durée" field of the…
- Answered
-
How do i track payments and update the new balance due?
We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…
- Answered
-
JSON: add a block based on a given condition
Hello. I am creating an XML file and would like to start with a JSON because it offers greater readability and ease of maintenance. In the structure of the JSON how can I decide to add blocks…
- Answered
-
Single user, multiple Macs
I'm interested in the standalone Mac version from the App Store for 35 euros, and store my data in iCloud to access from multiple Macs. I'm a single user,…
- Answered
-
How do i get my numbers $ to format right?
I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…
- Answered
-
Copy table including line items from subtable, to another table and subtable)
Hello everyone. I am trying for a few days to get this working but am stuck. Maybe someone can point me in the right direction. I have a table "Quote" and it has a subtable "quLineItems" where I add…
- Answered
-
How to Duplicate a table also with a subtable
Just quickly created Table 1 and Copy Table 1 for example, I'm wondering duplicate Table 1(Table 1-1) to Copy Table 1(Copy Table 1-1), but only able to duplicate the main table's field,…
- Answered
-
Beginner's question
This is so simple and basic I'm almost embarrassed to ask. I have a recipe database one of whose fields is 'Ethnicity', with various options (Chinese, Italian, Greek, etc.).…
- Answered
Answer questions and share your knowledge