selecting only first record meeting a criteria

Hi to all! Database tables Masters Reference Events inside a the Events Table I have this formula: let xEvent := Event; let xDate := Date; let x := (select Reference where Date = xDate and Event =…

• Answered

How many members can I invite? Is there a limit?

thanks

• Answered

format in time

Good morning, I have built a db where with as main table: Titles Fields include: Genre and duration. Now I want to create a dashboard. Select Titles. I get the genres in the chart but it does not add…

Extended Calendar Functions needed

i would like to use the Calendar Function createCalendarEvent() to add few more data, like: Event is all day Reminder at a specific time Notes Place Someone has the matching syntax for me?…

Collaborator field options

Is there any way to display more than the default for a collaborator field? For example displaying the email address for the collaborator in an adjacent formula field or in the drop down selection of…

Need to share 2 fields more

I have this script to copy the 'I_Cost Report' to a 'Histoty Reports' Table, but need to include the Date and comment fields to the 'History Reports' how Add this ? Thanks let newrec :…

Real time clock within a form view

Hello Again All, Is it possible to have clock (face or digital) that keeps the current local time within a form view? Thanks, Sam

• Answered

bold style

I want a certain field/column to be 'styled/formatted' a certain way. I have only been able to achieve the background I want for the column in the list view using 'conditional styling',…

Help setting up please

I am setting up my own small exercise business and want to track clients. Ideally I would like to: 1) Enter and track client bookings (enter booking, track if they attend,…

About the problem of extracting numbers with regular expressions

Hello everyone, I have a question that I need help with. I am using a regular expression to extract the number "1" after the asterisk symbol in "箱2.5L*1坛".…

How to copy PDF file from Image field to new record.

Hi there! Hope someone already had to go through this: I'm copying records from one table to another (and then deleting them). Everything seems to be fine,…

add a conditional constraint

Can 1:N implement the conditional constraint function shown below in the "视图"? I want to make the code of Products2 in Orders the same as the "The Warehouse" of the order.…

• Answered

Create sequential row numbers in invoice print form

I've modified the Invoice Template to make invoices and "line sheets" for a jewelry company; see screen shots of Invoice tab and the printed form. However, the Record #'s are fixed,…

• Answered

I want to copy the text content displayed in Formula. Is there a way to do it? Thank you for your reply.

I want to copy the text content displayed in Formula. Is there a way to do it? Thank you for your reply.

Need help to complete this script.

let me := this; let myA := first(select Artists where 'Artist Name' like me.'New Artist'); if myA = null then if dialog("Waiting answer ", "Artist not found.…

• Answered

Help please to finish database - Xero/Ninox link

We are looking for someone to help finish off a database. The main area we need help with is linking Ninox to Xero to transfer invoices/new orders. There are also a few other tweaks we need help with.…

Where did I go wrong?

I have always encountered this problem when importing from the Mac platform to Android. I succeeded once, but I couldn't import it later. Where did I go wrong?

Multiple attachments with SendEmail

How can I add more that 1 attachment with SendEmail - only ever had to sent with one beofre and all goo but now i need to add 2 files. QuoteSentFlag := null; let thisBody :…

• Answered

A question about Choice and Multiple choice

How to select or unselect all options in a Multiple choice by code in bulk? How to select or deselect options in a Choice by code? I want to use it in "Trigger after update",…

• Answered

SEND E-MAIL WITH ATTACHMENTS FROM AN OTHER TABLE

Hi, I've 2 tables : table 1 : CLIENTS table 2 : INVOICES In table 2, I have many records with attachemts and i want to create a button on table 1: "SEND INVOICES OF THE MONTH".…

Questions sur le choix multiple (dynamique)

How the first multiple choice affects the next multiple choice. I have uploaded the file, thanks for the reply。

• Answered

the issue of extracting data from parent and child tables.

I have included my question in the ninox file. Thank you!

• Answered

Get the hours from an appointment as an Array

Hello again. Sorry for all the questions all. I am trying something, that I'm sure MUST work, I am just not sure how to do it. Is there a way to stip the individual hours out of an appointment?…

• Answered