-
Alert message on CloseRecord
Hi guys, i want Ninox to check that a certain field is not null when closing the record and alert me if it is the case. if Type = null then alert("Remember to fill in the *Type* field")end it works…
-
Action after clicking on "send email".
Hello everyone. I have an email field for weekly reports I need to send out. When I click on the "letter" symbol of that email field, which will open an email in my Outlook,…
-
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.…
Top Contributors
Last Month