Scripting and Functions

How to modify multiple if statements (I'm not sure if that's the right way to express it).

In the database below I have two key buttons, I will temporarily call the code in "Key1" "if1". Now I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1",…

• Answered

How to use code to edit out unique non-repeating random numbers?

How to use code to edit out unique non-repeating random numbers? Thank you for your reply.

Help with Changing Multiple If Statement to a Case Statement

I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…

About writing conditional code.

I created a formula field in the home table. I set the condition that if the associated item in (copy here) (choose=1), it returns (A: 848); if the associated item in (copy here) (choose=2),…

How can I adjust this?

In the Home table, I selected the Alcohol option. The three charts below show the corresponding values. Starting from the second chart, I added the condition (choose=2).…

• Answered

How do I write the code within the formula?

I want to create a formula in the Orders table that displays "AAAAA" when only Warehouse A is selected in Inventory; displays "BBBBB" when only Warehouse B is selected;…

• Answered

Why is there no response?

I want to display the corresponding data after clicking the button, but 1 and 2 did not work. I verified with code 3 and it is correct. Where is the problem? Thank you for your reply.

• Answered

How can I structure the extraction of inventory data?

I have an inventory database. My products are recorded in two tables based on whether they are opened or unopened. (Unopened: whole boxes; Opened: whole boxes * units).…

• Answered

I have two questions about HTML code.

This is the starting code. <style> th { height: 30px; background-color: #4970FF; color: white; font-size: 28px; } td { background-color: #FE4A49; color: #FAFAFA; font-size: 22px; vertical-align:…

• Answered

transaction or deferred

the query below currently takes almost five minutes (browser) with just 30% of the final data expected. It's okay to wait this long , but I was wondering if anyone has an idea how to tweak its…

Retrieve the data from a button variable

Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…

• Answered

Retrieving the past 14 working days dates

So, I am creating fluid charts on our dashboard. I am having difficulty creating hidden fields that will have the specific #'s to work with. I want these fields to be calculated based on working day…

about the chart display problem.

I want to make my chart (image) to be sorted by value in chart 1 and display name in chart 2. How can I set it up? Thank you for your reply!

Importing Data into a Dynamic Choice Field

I know this was addressed many years back and at the time it did not appear to be a solution. However, has anyone come up with a way to import data into a dynamic choice field when the text being…

Count of records/table per day

Is there a way to count how many entries have the same day in some date field? Eventually, I need to calculate the average of records over several months,…

About the copy problem

I tried to copy the content of "copy" to "copy here", but they are not complete copies. Where is the problem with my code? Thank you for your reply!

• Answered

create options in choice field from variable/loop

It's easy to fill a dynamic Choice field with options from a table/query but how to dynamically create options through something like var options:=[] for i from 1 to 3 do options:=options + i end;…

• Answered

conditional unique() in column

my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…

• Answered

Scripting a button to print text from a choice field?

I'm making a print template for an envelope, with a button to print. In the table, there is a choice field for "Active Location" - example, choices are Site A, Site B & Site C.…

Button for create a new record which has a connection to a record

I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…

• Answered

Send emails with attachments with Gmail via Make

Hello, I send emails from Ninox with my Gmail mailbox using Make.com (Integromat) but it is impossible for me to send attachments. This is what my code looks like:…

get span of selected text

Is there a "dirty" way to use javascript to get the position of a selected text? I have a textbox (or a formula generated text, if that helps) and a user needs to select a text where I would need to…