-
Expression to extract text in a string to the right after a dash character
I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well,…
- Answered
-
Dashboard Help to Compare This Years Data to Last years Data to same date.
So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…
-
Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?
I would like to convert '你好' into 'nh' (the Pinyin for '你好' is 'nihao'). Can this be achieved through code? Thank you for your response.
-
Creating Chart with Multiple Series
I've searched around to see if Ninox supports this, but can't find anything. Can I create multiple series for 1 Ninox line chart?
-
Help with Button that inputs Date into parent record
Chronos is a subtable of Leads. When creating a Chrono, I have made an option that allows a user to push the button to create an "Active Date" that matches with the Date of the Record in the chrono…
-
chiose table from a variable
Good morning everyone! With this script assigned to a button, I would like that the name of the table on which to create a new record to be based on a field of another table where the script is…
-
Weird browser constraint bug
Hi all - I've encountered a strange bug with the browser vs app with a constraint that is based on a choice field. I have reference field that has a constraint and it was working in February.…
-
Heads Up folks - a neat byproduct of using hide icons.
I have used this to hide icons and you will note that the print icon is not included iro what to hide. The print icon is displayed. What is interesting though is the 'trash' icon when editing the…
-
Bizarre Results from Filtered Records
Ok, this has never happened to me before and is only occurring with one field. I have a simple choice field called 'Reason'. However, when filtering results by choice ID #,…
-
Can't get results to exclude a field value of 0.
I am having more difficulty than I should in having this following formula exclude any records that have 0 value in my 'contact attempts' field let curRec := this; let xStart := 'Start Date';…
- Answered
-
json add array
Hi everyone, i have spend several hours solving this Problem. I have this code: let myURL := ""; let myBearer := (select Einstellungen).'Bexio API-Token'; let contact_id := Kontakt.…
- Answered
-
How do I filter data in charts?
How can I set the chart view in the "inventory" table to only show "meat" and "bread"? I tried Filter but it only works when I enter one "food name", is there another way? Thank you for your reply.
- Answered
-
Dialog on Trigger on new record
Am I correct that a Dialog will not work (cloud version) when creating a new record. Example dialog below in case there is something wrong with it. let title := "Serial and/or Bundle Required";…
-
Find the minimum value in a group of records
Hello Ninox users! I’m completely addicted to Ninox but still young in scripting… so… Does anybody knows how is scripted the formula used to find the min/max/… of records grouped in a category (see…
- Answered
-
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