Automatically go back to the first tab

Hello everyone,how can I automatically return to the first tab every time I open it? thanks

how to parse a location from google geocode json?

I am able to get the JSON to return from the google API call, but when I attempt to use item function to parse the JSON, I am getting errors. I attempted to use the solution at Parsing…

Count number of records that fulfil a search criterium

Hi! I have a table called Residents that are based in different towns. Each resident has their town as a field entry in a drop down list that includes Gothenburg, Skaraborg, Ludwigsburg.…

Extract year from date field in text format

Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…

Sub-Tables - Add existing record

Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…

• Answered

Script for transfer record N:1

I had to create an additiona table with relation N:1. Table A Reference N:1 to Table B On Table A now I have records included and I need to Include them in the Tabke B, isthere any scripts to do that.…

• Answered

Detect list selection

In a table view/list, select a row and the form slides out. One can move the selection up and down the list and the form data changes to reflect the selected row. Standard Ninox behaviour.…

Get data from unlinked table

Never finish! I have "Service" table that contains: Insurance End Service Date Linked Table "Car Registry" Data From a "Repair" table I have to make a formula to calculate the price the customer has…

Update Reference field from Text Field

Hello everyone. Assume I have 2 tables. 1. Customers -- It includes a field named "Company Name" 2. Service Reports -- It includes a popup field named "Customer" where I can select the company name…

• Answered

Ninox Database for Mac - New Entries not Saving

I have Ninox Database for Mac (3.7.6) running on a MacBook Pro laptop with macOS Monterey 12.6. I have a large “Home Inventory” database with 859 items, that will no longer save any new entries.…

Problem with creating PDF after update

Hello Everyone I need your help, because the only answer, that I am receiving from Ninox is - take a part in our Webinar! I have the following problem - my system is working already more than two…

Google Maps - iframe in Ninox

Does anyone know if there is a sample DB that uses a location field in conjunction with an iframe to display a location field in a map?

Need Help to create a History Control Table

I need a Control Table, where every time the FechaR3, FechaR4 and FechaR5 are met in the Documents Table, they are copied to the Control Table with the Document Name, the Code and all 3 Dates.…

• Answered

NinoxCloud, automatic data saving

Hi there, Does anyone know how this works ? Is it purely at random and set to work, say, five times per day or does it depend on the team activity regarding a particular database?…

Calendar for photographers

Ciao, I am a photographer and I mainly deal with weddings. I am very happy with Ninox to manage my entire business and am also recommending it to other colleagues who seem enthusiastic.…

date change

I am having the issue of the date being changed after I enter it. I am using the DATE field to pull up the calendar so I can select a date and after it is selected it gets changed to exactly 1 day…

Auto generated email

hi, I'm trying to automate the email report. Like my aim is to fill fields and then my email would be ready. Here my workflow : Fill fields > Generate email > Mailto from ninox I can generate well my…

Optimize Formula

switch Medicion do case 1: (select DOCUMENTOS where 'Ganado REAL' = 10) case 2: (select DOCUMENTOS where 'Ganado REAL' = 50) case 3: (select DOCUMENTOS where 'Ganado REAL' = 80) case 4:…

• Answered

Alert function - trigger after update - cloud version

Hello, i would like an alert after trigger after update. On ipad/iphone this function works ok. On cloud version this doesnt work, when i use the same script with button everything works perfectly.

• Answered

MultiLine Text field with multiple rows alongside in form

Hi, I'm not sure if this has been asked before, but could not find it when searching. Apologies if it has been posted. I am looking at Ninox to migrate date from another database platform,…

Hours result from appointment field

I have an appointmenet field which has started giving weird results in a formula providing hours worked. This is the formula: duration(appointment(datetime('DAY END'),…

Field alignment logic

What is the logic behind "bottom field alignment"? Have experimented with spaces etc. - no luck so far - is there a way to "top-align" fields? J:)

Gruppierungen in einer Tabelle berechnen

Hallo zusammen, ich habe in der Tabelle Rechnungen eine Ansicht erstellt die mit "yearmonth"(Datum) die Monatsumsätze (Nettobeträge) gruppiert. d.h. 2022/7 ; 08/2022 usw. angezeigt.…

Button to save a pdf when multiple print layouts are available

Hello, i have a form and multiple print layouts (that's because from the same data in the form, I need to have many different papers created). 1. Is there a way to add different buttons the form (one…

Can't see records, while they can be searched and found...

This seems like a basic problem, but I am not to able to solve it. I have a database of wines I have in the cellar, and I retire them by the bottle. So when all bottles of a certain wine have been…

• Answered