-
Use a date to lookup a table to get a code
I've built my database which I use to see progress as I complete tasks. Thanks for all the help so far! When creating a new data 'page' I seen to have to take a number of steps - too many clicks -…
-
Sales growth
I am trying to display how my sales have been increasing/decreasing over the year. It would be interesting to see how many orders have been made in a week/month.…
-
4 week running average
As a truck driver, I get paid by the mile. I need help figuring out how to look up and calculate the average miles driven in the last 4 weeks (6 weeks, 13 weeks).…
-
Order by desc
I have this in a function let s := this;let ntxt := "";for d in (select Orm where Dato > today() - 365 and Heste = s) order by Dato do ntxt := ntxt + d.Dato + " " + d.…
-
Sum with multiple condition (dates and multiple choise field)
Hi, I searched a lot but found nothing that is right for me. I have this formula. Basically I would like to sum the expenses between one date and another but which have as their parameter a specific…
-
Formula for calculate total of recurring expenses
Hi, I've been looking but can't find a simple solution to my problem. I have recurring expenses recorded in records where there is a start date and an end date.…
-
Restrict Duplicate entry
Hello, I need help from you people. I have a code in a field (Record ID) in "trigger after update". It works to delete a new entry if it has the same ID.…
-
code TRIGGER AFTER UPDATE
Hello eve Hi everyone, I need help with a "Trigger after Update"As soon as I select from the Combo box "Chi?" automatically must select the same answer in the "Consulente" combo box.…
-
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?