-
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.
-
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
-
loop in query for view -- how to aggregate?
I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…
-
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
-
Why using a choice field's text does not work in an "if" statement?
Hi all. Using the number next to the choice's text in an "if" statement works. Using the text part does not. Why? Looked in the documentation, the only example I could find does use the number,…
-
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.…
-
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…
-
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
-
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…
-
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