-
Selecting
Hi I have a table with "date" and a "Type" Ind a function field i want to show the last date with type 2 last(tablename.date) where tablename.type=2 I can get the last date with last(tablename.…
-
View does not sync to my mobile devices
Hello. when I make a view in admin mode in the Mac app on my Mac, it is not synced to my other devices like my iPad and iPhone over iCloud. I tried to find something about it in the manual but I…
-
How to show image with '-' or other special character in URL?
Hello, I need to store and show images from e.g. digikey.com.The digikey URLs for their product images contains special characters like '-' and the url is a HTTPS url.…
-
http with method post
Hello, i try this code bellow in a button let response := http("POST", "http://localhost/test.php", {myParameter: "myParameterValue"}, {'Content-Type': "application/json"});if response.…
-
Collaboratori al team
Salve, come si può fare per creare delle password diverse per ogni collaboratore al fine di avere accesso al team e disporre di database diversi per ogni progetto?
-
Whats the default Username and Password on Server version?
I have installed the server version and its running on port 80 but I couldn't log in. What's the default username and password? Thanks!
-
Need formula for Button to create a new multi line text field
I would like to make a button that would create a new multiline text field within the current record. This way, I could add a new note/comment as needed, for each record.…
-
extrapolate number of month of current year from 2 dates
Hi, I need to extrapolate how many months of the current year there are between 2 dates. For example: I have 2 dates 05/01/2021 and 05/01/2022. I would like to know how many months of the current…
-
Aiuto Please I must do a TIGGER AFTER UPDATE
As soon as I select a choice from the "Chi?" automatically he must select the same answer in the "Consulente" combo box.I state that "Consulente" is a linked table and that is "Chi?…
-
Trying to "hide" records in main table
I am trying to "hide" records in my main table (Orders) by having them move to sub table (Received) when the field (Received by)= 1, 2, or 3. I am not sure how to write the code correctly to get it…
-
Merge 2 similar DB
Hi , From the beginning, I've had one DB on a private server and a similarly links structure and fields other DB on Ninox server. I've upgraded them simultaneously, but I may have forgot some,…
-
How I can prevent duplicate records being added?
Hi. I'm a new user on my first project and have set up a simple database. I need to find out how I can prevent duplicate records from being entered in a table.…
-
Mit JOIN eine Leerzeile in eine Listenspalte einfügen, falls kein Datensatz vorhanden ist?
Hallo zusammen, ich habe eine - hoffentlich - einfache Frage. Ich erstelle eine Print-Darstellung, die den Status der erteilen Aufträge und dazu erhaltenen Lieferungen zu einem Projekt auflistet.…
-
Query
Hi, I have 2 tables. Table 1 : Contractor : Nr Firm 001 IBM 002 Ninox ......... Table 2 : User : Id Nr Name 01 001 Glenn 02 001 Bruce 03 002 Tom ……… What I would like to obtain is a table…
-
How to count days
Hi guys, I'm struggeling a bit, trying to figure out how I can count the days in a contact history table (to be used in sales effort stats) I have a "contact-History" table in which there is a "date"…
-
Problem with printing in Windows and Android.
Hello everyone! There is a problem with printing in Windows and Android. Preview displays correctly, and when printed in pdf, everything breaks and the encoding is different.…
-
App login (no login with Google AC)
So I can login on the web(Ninox) with Google however, I cant see it on the App and I cannt login. Am I missing something? or does the App not support Google login?
-
Formula to search records with dates
Hi I'm looking for a formula to obtain as a result the records that have a date between a date that I can insert through a date field and another that I can insert into another date field.…
-
How to set a value for a switch elements
Hi, how can I set a switch value when I press a button?
-
how can i let someone else view my data table
how can i let someone else view my data table
-
Script: test for null or empty'
I want to say: if This Field is empty then do this else do that end How do I test for 'empty' I thought I'd seen reference to 'null' in the manual but I'm learning about the manual....
-
Nesting 'if'
Maybe if I knew which script launguage ninox uses I'd have better luck with Google. I think I want to nest an if Following on from my previous if 'Year Code'.…
-
Script: Test for 'if this is true and that is true, then..."
I have a working script which does what I wanted, some reference numbers need to be in the format AB-C-D and others ABCD. With and without hyphens depending on two tests. if 'Year Code'.…
-
Retrieving a deleted record made by mistake
Hi, Is it possible to retrieve a deleted record made by mistake? Thank you Andreas
-
http() function isn't working
Or it isn't working the way it used to. Can anyone confirm this?