-
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
-
Differenz zweier Datensätze berechnen
Hallo zusammen, meine Tabelle hat die Felder „Datum“ und „Betrag“. Die Tabelle hat derzeit 5 Datensätze (31.12.2019 … 31.12.2023) Ich möchte nun den „Betrag“ des „Datum“s = 31.12.…
- 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
-
Records filtered by Dynamic Multiple Choice
So, I have many fields that are dynamic "single" choice. My goal is to filter data using a multiple choice dynamic field but am having issues with scripting it correctly.…
- 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
-
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
-
Warning on button coding: "Field must return dynamic values..."
Hi there! After some trial and error, I came out with this coding that works as expected but I can't get rid of the warning sign saying: Field must return dynamic values...…
- Answered
-
Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
@Fed In the table AUDIT I define the Audit #, Date Audit, etc... and the Area to Audit (Multiple Choice dynamic) then click on ADD to Audit and then update the Table Audit Plan,…
- Answered
-
Date format in formula
I am trying to set up a multiple conditional if statement. Having trouble figuring out how to put a date for the script to check against. Here is my code.…
- Answered
-
Need the Diferent Between Two dates, Without Weekend and Holidays
I have Two days example 4/Mar/2024 and 11/Apr/2025 need the days wiithout Weekend and Holiday. I have define the table Holidays.
- Answered
-
About signature Questions
How to copy the images in the (signature) field of table A to the (Image) field of table B? What should the code look like, thank you for your reply.
- Answered
-
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
-
Distribute dates between two others days.
@Fred I have the fields Plan 1 to Plan 5 with the following milestones 10%,25%,70%,90% and 100% in the Plan 1 date field I have the start date 8/02/2024 and in the Plan 5 date field I have the date…
- 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
-
Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
Need a script that find the info by (Today, Last Week 5 days, Last Month, Last Six Month and Year.) Somebody helpme.
- Answered
-
How can I create a dynamic multiple choice that uses selections from another dynamic multiple choice.
dMC A item 1 item 2 (selected) item 3 item 4 (selected dMC B shows the following item 2 item 4 The user select items 2 and 4 in dMC A. dMC B shows only the items choses in dMC A
- Answered
-
Ninox App Anomaly 3.11.5
Context : System: macOS Sonoma 14.3.1 App: Ninox Database 3.11.5 My databases No more way to deploy the context menu on each local or iCloud database This works for databases on Public Cloud How can…
- 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
-
Pop-up field showing wrong columns
I had a Combobox field where the Linked record was showing the "Trip Name" column and all was well. I decided to change the Show Field As type to Pop-up,…
- Answered
-
How to use code to calculate the number of days in this year or next year?
Thank you for reply.
- Answered
-
Convert Time field to Number field.
Need to convert the Total Hours sum((select 'Booking Time').Time) to a number field.
- Answered
-
Generated an array with record numbers in a formula field.
How Generated an array with record numbers in a formula field. Array. 'Booking Cod' into Formula
- Answered
Answer questions and share your knowledge