How do you extract data from a text field? Regular expressions appear to be a mess in Ninox...

How do you extract data from a text field? Regular expressions appear to be a mess in Ninox... Specifically, I need to extract the text contained in the red box in the image below: Thanks, Marvin

Duration( Appointment ) = End( Appointment ) – Start( Appointment ) result in hours only ( hh:mm ) not days (dd:hh)

Hi there, i am using " Duration( Appointment ) = End( Appointment ) – Start( Appointment )" formula, and the result is displayed in days and hours. Isn`t there an option so i can display the result…

How do you multiple or divide two formulas in a formula?

How do you multiple or divide two formulas field in a formula? I keep getting error saying Invalid operator: boolean / number. Thanks for the help.

Whi does while loop not work

Hi, I have a simple loop but get always an void and no result in x let vnaam := ["a", "B", "C"];let x := "";for lst in vnaam do let x := x + item(vnaam, lst)+ ", "; voidend;…

Datensatznummerierung ändern

Ich habe ein Tabelle bzw. Datenbank von 36 Einträgen. Diesen Einträgen wird automatisch eine Nummer zugewiesen. Wird ein Eintrag gelöscht fehlt die Nummer.…

How to trigger a change in date?

Hello I posted a similar a few days ago that was unanswered so i'm posting a simplified version of it. I am trying to figure out the code to trigger a change in date by one year.…

Date Field Issue - 1 Team member's changes all show up as minus 1 day to the rest of the team

My team has 1 team member who is in a different timezone. We are in PST she is in CST (2 hours difference). If she changes a date in a date field the rest of the team sees it as the day before.…

Why is the date wrong?

I have a customer form and whenever the contact opts in/out out or leaves the company - It writes an entry into an 'GDPR audit' table However I have an issue with the date- for example - Both my mac…

How do I find the storage address of an image / copy image outside of Ninox ?

I have a “Photo” image field and I would like to be able to share it outside Ninox, either by exporting it or via API REST. When I do that, I just have the name of the image: “G1812/Jacques 3.jpeg ”.…

Dynamic choice field - showing Id instead of description in print view

Can anyone help please, this is driving me mad. I have a table called 'Inspection Report', and within this is a dynamic single choice field pulling from another table called 'Mechanical Services'.…

Search for tables with part of their name or with certain conditions

I have a mac database and I will need to create from a button a separate table for each customer in my database (the list of customers is another table).…

Field after update triggers.

Is it possible, in a field after update trigger, to view the previous value and the updated value? If so, would it be possible to give me a bit of sample code.…

Trigger after update previous value.

I created my own audit trail, where when a field is modified, another record is created and linked to that table that records the modification. One example is: (and this action is recorded in a field,…

Why Im getting endless loop here?

let Srch := 'Search';let Find := false;let Counter := 1;while Find = false do let Slct := (select Company where Id = Counter).Employees; if Slct = Srch then'WD TXT' := "Found it";…

Combo box only showing first 100 fields from the source table

I am using the trial version and not sure whether that is the problem but the drop down combo box which has over 300 fields only shows the first 100.

How to limit user to fill the fields in the form, but not see the list of records in that table

Hello! I searched for the solution, but cant find it. I have a tablet that i give to a client so he can fill the form in the table Clients. But i dont want him to be able to see other records in that…

Print limit

I have a data base invoice set up, where there is a subtable of linked line items (products and prices) plus a totaliser function summing all lines to give a total price.…

Table function

By which I mean a function that can be called from any field/column in that Table. I have a function to update a couple of fields based on the values of 2 other fields and really need to call that…

Drop Down Combo Choice Box - Load with value from another table

Does any one know if it is possible to have a combo choice box on main form and instead of manual prefixing the choice list - have the combo look up the choices dynamicly from another table ie I want…

Filtering with many arguments in a related table

Hi, I wonder if you can give some ideas on how to find a solution for this: I have a table of Spares related to a table of Instruments, I have a Report table that stores many instruments in the table…

Administration/Maintenance/Wrench mode

Is it possible to detect this mode? I thought userHasRole("admin") could be used for this, but a user's rights are not the same thing as being in 'Administration' mode or not.…

Another Multiple Choice (Dynamic) question

How can the list of choices be filtered? Sorting the list is straightforward, but I cannot figure a way to filter them. By which I mean e.g. select choices where Id > 2 The idea is that the list of…

• Answered

Import attachments or send file via rest api

Hello, I've been trying to import files into my ninox database for a long time, but after contacting the support we noticed that it was impossible because I use characters not allowed: accent, __,…