-
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.…
-
Colour in new Ninox version
Hi. I really like the new look of the new version to come. This is a big step forward!Does anybody know the colour code of the main frame (the darkish, purplish one)?
-
Repeating dates
I need to have a date field that repeats on a particular day of the month, repeated monthly. Is this possible?
Answer questions and share your knowledge