Sharing DB ISSUES

I have requested help for Ninox and don’t feel they are too forthcoming with that. We have a database that used to share with field technicians. It hasn’t updated in over a year for them.…

About the issue of allowing edits only when conditions are met…”

I have created two tables for employees’ orders. I want to allow modifications to Customers.text only when Orders.Salesman is the same as Customers.Creator.…

• Answered

Change the row height in views on Dashboard

So we all know that you can change the row height on table rows from this to this etc But I would like to know if it is possible to change the height from the default view row height in table views…

Create new record with outside button

Hello everyone, there is a “daily result” table and a button that is not in this table. I need to program the button so that it creates a new record in the table “daily result” and copies the value…

• Answered

How to locate N:1 relationships that contain data?

I have created an Orders table that is associated with three tables named after people's names. I want to use a code snippet to locate the associated tables (the ones that contain data).…

• Answered

selecting rows on a table using header column filter

I have a table with a few columns and one named MAG that contains text. Some rows in this column are empty. I want to show in the tabular view of this table only the rows that have the MAG column…

• Answered

Formula/Script behaves differently when in Full Screen View

Hi Ninox Forum Followers, I have a formula/script as found below that behaves differently when in the full screen view. The behavior resorts back to displaying the time when the full screen is…

• Answered

Triggers and table conditionals limitations in Local/Cloud

Hello. I am on the Starter subscription and I found two problems: The same Trigger on create that works in any workspace (cloud) does NOT work in local (in MacBook app).…

• Answered

Error message

I get the following error message: Inconsistent calls to Snapshot._lock() / Snapshot._unlock(). Any idea somebody? Thanks in advance!

how to adjust what is returned from a link to another table

Hi, I have a table with a relationship field (N:1) to a second table. The relationship field in the first table is set to show the 'Name' field from the second table.…

• Answered

Field label on the form different than the field name in the database

Hello@Fred , I am trying to create a Sales Module for small business and the following question came to my mind so thought of taking your expert guidance in this.…

Number of days between 2 days of appointment

Hi I have the function date(start(appointment)) but I don’t have the function date(end(appointment))! How can I calculate number of days between 2 appointments date?…

• Answered

Aide francais

Bonjour je cherche une personne qui parle francais pour obtenir de l'aide dans la création de ma base Merci

Formulate View field from multiple date entries?

I have a View field to show me fitting appointments between 2 selected dates (start date & end date), where it shows me all appointments where the "Fitting Date/Time" falls in between these:…

Is it possible to add a condition at the beginning of the table?

I am using concat here to display the data from (invoiceitems.‘1 or 2’). Is it possible to use conditional statements in the code, for example: if it returns 1, then display 0; otherwise,…

• Answered

Forumla Conversion

Hello, I have a subtable which has some fields that does some calculations (see screenshot). The profit field is worked out on Project Cost Quoted - Project Time Cost,…

Regarding the issue of matching records after splitting the data.

I have created three tables: "product," "invoice," and "Create." In the "Create" table, I have set up a button. I want to quickly create orders by clicking the button.…

• Answered

Regarding the issue of storage space.

Hello everyone, regarding the database size of Subscriptions, what are the impacts? My database download is only around 1M, but it is already showing that it has occupied 4GB of storage space.…

• Answered

Sudden change in screen layout.

I don't have a version update as far as I can see - 3.12.7 is what I have now but this morning when I loaded my APP everything is messed up UI wise. Anyone else have this happen or do I need to…

Script Error on line 15

#{ Get the selected categories from the Choice (dynamic) field 'Categories' in the Control HH table }#; let selectedCategories := Categories; #{ Start an empty list to store the associated Rates to…

• Answered

Argument with Ninox AI and reference field

Hi, I'm new to Ninox and the AI option is just an amazing lifeline I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached…

Is there another way to display the filtered data?

I want to display the data according to the SHOW in HOME, but I can't sort it by the number of repetitions in descending order. Is there a way to use Functions to display it?

• Answered

Buttons in Tables View (Ansicht) needed

I need to have the possibility to have few buttons in the view of tables, because i want to have a list of different Students and then have a button for each day and if i press a button,…

The script don't work

" Variable 'Categories_>' is n:1 relationship "; let catg := 'Categories_>'; let rate := (select Categories where Category = catg).Rate; 'Rate by Categ' = rate I try once choose the 'Categories_>'…

Dynamic choice (programatically selected)

Hi All, My doctor only wants to see the items that are relevant to an appointment. Items is a dynamic choice field. I am able to find out the items that he can't charge for that appointment,…