All topics

index with regex

I'm trying to find a way to get the index (i.e. start position in a string) for a regex pattern. I can use text, replacex, extractx for various operations but not for getting the index,…

• Answered

Field txt to date(dd/mm/yyyy)

There are any script to convert a field txt to a date format (dd/mm/yyyy)

• Answered

time(time field) problem

I'm in NY, EST. I have a time field "TF" that says: 2:30 PM so time field TF contains 2:30 PM if x := TF then I get x= 9:30 am if x := time(TF) then alert(x) from a button shows 4:30 AM ultimately,…

• Answered

Error message before sending an email with attachments

Hello, I created a button allowing me to add documents downloaded from a client, directly into the image fields of a recording that I want to send by email, I got the error message:…

Create a zip file of all invoices generated with printRecord()

Hello, I would like to create a zip file that includes all invoices from all records in the "Transactions" table. Invoices are usually obtained individually by clicking on a button containing the…

Change the sequence of the tabstops

How do I change the sequence of the tabstops within a table for adding new datafiles. That means jumping from one field into the next

How use popupRecord() and openRecord() ?

I try to create a button to open (may be in a popup) to go to an other record but I don’t know how use this fonction. Someone can help me please ? Thank’s in advance. Gwendal (Sorry for mistakes.…

Change Status on Multichoice Dynamic

I am trying to get the 'Status MC' change to 90% when I update the date in 'Real 4' but if I delete the date it goes back to 70% 'Status MC'. I try this but don't work.…

• Answered

making PDF with rich text

Please can you tell me where it goes wrong? I looked in the manual, the forum… It’s about printing rich text I make a field with rich text: html("<h1>To</h1><p>Filip Schumacher</p>") In the form it…

Parse Dynamic Multiple Choice into JSON object

I have a DMC field that takes these values (dynamic value): let all_entities := (select elements); let my_event := this; let my_elements := ((select elements where 'parent entry'.…

• Answered

Dynamic choice applications

table1 is the data location of the material type/material plan/material number table2 is the table for selecting materials how to display "NO" in table2 on VIEW (such as image 2) Thanks

Conditional Formula Request

I need some assistance to create formulas that returns values based on two Choice Fields in my stats table. The choice fields are 'Cohort Year' and 'Cohort Term'.…

Conditional email content

Hi every one and Happy new year ! In a database, I have several check boxes and I want to send an email in witch appears only the title list of all the boxes that i've checked.…

• Answered

Reference field trigger error

Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…

• Answered

Button to Send Message and Create Entry in Log

Hi, can someone help please. I'm almost there. I have this Tab So when I click on 'Join Reminder' button it creates a Text message for sending and this works perfectly.…

• Answered

Staff schedule

How to solve the problem with staff scheduling? so that the names of all employees who are supposed to work that day and at what time they start work are automatically displayed.…

Updating records in the DB

I have several databases, and once a month, i need to transfer information from all databases to a mine database. The problem is, that the data is not updated, it is copied.…

• Answered

how increse de memiries of my package?