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

Create record in another table on a switch

Hi all, Bear with me as I'm a new user and don't have any tech / db-skills. If the answer to my question is in another post, please show me a link. I've tried to search the topics,…

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

Scaling up - multiple users

Hi, What happens if we use Ninox to build a field app, and then need each employee (up to 25) to use it to enter information? Basically i cant afford each user to pay a licence,…

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

double click in cell to activate input - buggy sort of

I notice that the 2 x click in a cell does not always work as expected. I recall others having this problem and advising how to get around it. Sometimes when I 2 x click the record slides in rather…

Dynamic Reports

Trying to create a table of check using a WORD document with no success at all so far. The first screenshot is the Word table with fields which I believe is correct.…

How to use code to calculate the number of days in this year or next year?

Thank you for reply.

• Answered

getting started

can you give me some extra days for free trial?

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

Uppss What happend ' Problem save database'

Can't save any database, and don't have any problem with internet

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

Inquiry about Generating PDFs and Sending Them via Email in Ninox

Hi Ninox community, I'm currently exploring the trial version of Ninox and I'm impressed by its features so far. Before committing to a subscription, I have a question regarding a specific…

single choice dynamical always selected

I have a dynamic choice field. I put in the trigger "after creation" to select a value in my dynamic field. Everything works perfectly, except that the cursor remains on the field while the selection…

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…

What do the different colours for Database icons signify?

Some icons are blue; some are grey. Why?

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!