Scripting and Functions

Questions about writing

The file has been uploaded. Thank you for reply.

• 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

I want to enter multiple items.

I appreciate your reply.

• 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?…

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

How to open an image through a function field.

I have an image for a registrant in table A I display that image in other tables using a function field. Is it possible to open that image by clicking on the function field?

Copy to Clipboard

Is there a Ninox function now? I was looking for a way to copy the content of a field and found this post from way back: html("<button onclick='copyToClipboard(""" + concat(SERIAL) + """)'>Copy to…

How to write code to batch update data in two or more child tables?

Table2 works if there is only one line of data. However, I need to modify multiple lines of data. How do I modify my code? Uploaded files,Thank you for your help!

• Answered

<span onclick> , Is it possible in a Formula (html) with for from to do loop ?

Hi, I have seen resent posts where span onclick is discussed. I wonder if it is possible to implement this in my example. I intedent do upload this as a DB,…

• Answered

About code Questions

上面的代码出现了问题，数据变得一样了。 “物流码” HTTPS://M.LZLJ.COM/R/122169506032380086 HTTPS://M.LZLJ.COM/R/122119277562447981 HTTPS://M.LZLJ.COM/R/122121718875948831 HTTPS://M.LZLJ.COM/R /122179735097552622 HTTPS://M.…

• Answered

select where statement.

I have two tables, MANUFACTURER and INVENTORY (1:N) In the Inventory table I select the Manufacturer - so far so good. I have added a view which I want to use to display all other inventory items…

• Answered

Please teach me how to use this global function :-)

This code can be used in global functions and I want to make use of it. I know I can call it from a Form/Tab as needed but how? "--- This controls the HUD icons top right ---";…

• Answered

About batch write Questions

我是 Ninox 的初学者，我的代码遇到了一些问题。我正在尝试将“1”中的信息一一写入“2”中。你能帮助我吗？提前致谢。

• Answered

Need Script for calculating workdays between 1st record, 2nd record, so on.

Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…

Sort json?

Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…

• Answered

Delete Files added to paper clip

I have an archive that I want to BULK delete various images attached to records. I want to keep the records but no longer need the images that are attached to them.…