-
Need to generate an invoice number type field with year specific format.
Hi, I have little to no understanding of code, could someone help me create a formula number please with a specific format. We want to create increment numbers with each new data entry to a max of…
-
Probleme mit cnt auf drei Spalten, eine Spalte ist Unique
Hallo Ninox Freunde, ich hänge gerade in meine Datenbank fest und wollte fragen, ob ihr mir kurz helfen könntet. Ich wollte gerne die Anzahl (Unique) auf Bildtitel in der Sparte "Color",…
-
Populating fields in one row with data from another table
Greetings, I have pretty good experience with MySQL, but I'm loving learning this new software. I'm helping my daughter build a database for her softball coaching schedule.…
-
Impossible to put a line in the form !
Hi When I select a line in the layout option it disappears ! I click on the key, it appears, I can modify it…but when I deselect the key, it disappears ! Can someone tell me the secret ?
-
Mixing Arrays os strings?
Hello Ninox gurus! I have 2 strings from a sub-table: String 1: Number1, Number2, Number3..... String 2: TextA, TextB, TextC.... I need to get: "Number1, TextA, Number2, TextB, Number 3, TextC....…
-
Counting a specific set of subrecords in each recordHello, I have simple question. I build a to-do app and I want to count all the accomplished items in for each special project. I made a formula field with this syntax: cnt(select Tasks where Status like "Accomplished"). But now it counts all the tasks in every project. Is there a way to count only the tasks in a specific projects. Thanks for answering Hans
Hello, I have simple question. I build a to-do app and I want to count all the accomplished items in for each special project. I made a formula field with this syntax:…
-
Lock a cell ?
Hello how to authorize only one number?
-
See a linked table without using a magnifying glass
Hi, I linked 2 tables : table 1 ant table 3 goût,To see table 1 when I am on table 3 goût I must click on the little magnifying glass.Is there a way that this table will automatically appear without…
-
See a linked table without using a magnifying glass
Hi, I linked 2 tables : table 1 ant table 3 goût,To see table 1 when I am on table 3 goût I must click on the little magnifying glass.Is there a way that this table will automatically appear without…
-
Import first image Google in ImageField
I'm trying to import with a button the first imageresult of google "//Building URL field";let myURL := "http://www.google.com/search?q=" + 'Nome Hotel';"//Putting the URL in the URL-Field to display";…
-
How to add a logo for my signature in a email with attachment?
I try different way to add a logo of my school with my name but nothing works when I send the email. Formula, http, fields
-
Update Field in another table after update
Hi, I am trying to update a 2nd table with a new record and add the SKU field from the first table. Table 1 (Products) has a table reference to Table 2 (Stock Take Tracker).…
-
How to delete all rows in a table?
This question might sound silly but am I missing something? In a spreadsheet program such as Apple Numbers, you can simply select all rows and hit delete to delete all content in the rows.…
-
How do I know if the appointment date includes today
if today() = Appointment thentrueelsefalseend This seems wrong, how can I do it, thank you
-
Anzeige verknüpfter Datensätze einzeln in Tabellenansicht
In meiner Tabelle "Eingangsrechnungen" habe ich die verknüpfte Tabelle "Zahlungsdaten". Dort trage ich Nettosumme, MwSt.-Prozentsatz und die Berechnung der Bruttosumme pro Rechnung ein.…
-
File Name Pattern of Image Import
Hi, I want to import product images to Ninox. The file pattern is URL/SKUa.jpg. When I create the image file I add a letter a,b,c,d etc to the end of the image SKU, but before the file extenstion (.…
-
"ImportFile" error with Api Google Maps
Can someone explain me what is the error in the importFile-line? "//Define some variables first";let Loc1 := urlEncode(text(Location1));let Loc2 := urlEncode(text(Location2));let Loc3 :…
-
Time format for duration
Hello Ninox Guru's, As a beginner I want to enter the duration of a piece of music in a database: 0:30:27 (30 minutes and 27 seconds).You will have to calculate later because the times of different…
-
select where and where
WHO KNOWS THE SOLUTION? I have a choise field in a repair database: sort of customer: 1 or 2.I book repairs for both customers 1 and 2.All records have a unique repair number,…
-
NINOX BETA FOR MAC
Is it possible to download the NINOX db for MacBook (Beta) ??. When will the new update be published?
-
Enter date directly into a formula
Is there a way to add a date directly into a formula. Have a Monthly Table and want to show the number of days since 22/10/2008 (DD/MM/YYYY) for each month.…
-
How to send file/file content to NinoxDB via Zapier ?
Hello @Ninox Support Team! I have created new db and in that I found table 'invoice'. I had treid to create record via zapier and record has been created also,…
-
Server not responding
Hi support, today we have the same problem as BlairW had two weeks ago: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/server-not-responding.-please-check-your-connection.…
-
I need help with "do as server" script
Hi, I have button for duplicating the record to subtable and also the items from records. Before the button is worked with this script: let b1 := "Major";let b2 := "Minor";let b3 :…
-
Suche Hilfestellung bei der Sortierung einer Ausgabe von Daten + Darstellung in einem Diagramm
Hallo, ich habe hier diese hübsche Formel: let d := 'Datum (Zusammenfassung)';for p in select 'Historische Kurse' where Datum = d doconcat(" " + p.Aktien.Aktie + " " + p.Aktien.…
Answer questions and share your knowledge