-
button for Duplicate a record and its links to a sub table
Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…
- Answered
-
Coding a popup dialog in a for loop if error
I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…
- Answered
-
Beginner: Database for research project - Transition from Excel
Hi, I'd like to use Ninox for my research project to store some information regarding fieldwork (date on which a specific sample was sampled, comments, photos, etc.…
-
Photo preview but no import
Hi, I'd like to use Ninox for a project that involves many photos. Would it be possible to just refer to an image, and let Ninox generate a preview image but not import the image to reduce the size…
-
openTable() with sort order.
Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…
- Answered
-
New functions
Hello everyone, I put up this post to list all the new undocumented features of Ninox. I started a post here (https://forum.ninox.com/t/g9hs0n7/v3-7-11-new-functions) but its title limits it to…
-
Constraints issue
In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…
- Answered
-
Build a Report Advice
Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…
-
Code about random numbers
I want to write a code for generating a random number that consists of six digits. The number should change every month, reflecting the progression of time.…
-
Help with multiline text field inside an html() function
Hi, is there a way to display a multiline text field inside an html() function without losing the multiline feature? I mean, when a use html(" + 'multiline text field' + ") the text is displayed as…
- Answered
-
There must be a better way...
I have the following code: let curRider := 'Team Membership'.RiderID; let rndJmp := RiderResults.'Round Type'; let x := for loop1 in rndJmp do AllResultRecIDs[RiderID !…
- Answered
-
Button script to select/link record on child table
Using the Invoice Template, I have a the 'Invoice' Table with an embeded 'Invoice Items' table. I add items to 'Invoice Items' by selecting existing records previously input in the 'Article' table.…
- Answered
-
Script not working dilemma
This simple script does not work in a working DB but is 100% in a restore and I cannot figure out why. No fieldnames have been changed, removed etc. The script does not indicate anything is amiss.…
- Answered
-
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
-
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?…
-
LIVE clock script.
This came about because of a now 'answered' post. I asked ChatGPT to modify the script to add the AM/PM clock and Day/Month/Year. Hope it proves useful.…
-
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…
-
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坛".…
-
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.
-
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
-
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