-
Avoid delate table
Hello, with the edit mode disabled, how can avoid to delate a table? Thanks.
-
Submit button with required fields notification.
Hi, I have a very limited knowledge when it comes to writing scripts so please consider this when answering. I have form for managers where they have to fill up information about sales and production…
-
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
-
Frustrating time tracking down error fieldnames.
For the past week or so I have had field not found issues when opening a particular table. Spent hours trying to find the missing fields as reported. Even Ninext could not see them.…
-
Send array of object json with httpr
Hello Everyone, I try to send with HTTP() function a array of objects json ans i cant. Have you a little sample to send a array on objects json to api. I need specialy how to create te array of…
-
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
-
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.
-
Dropdown menu on database icon not working
The dropdown menu on the upper right corner of the database icon at the Ninox home screen (showing rename, and other functions) doesn't work since update 3.11.5 update (Mac desktop version).…
-
Ninox will not open on my Mac
I installed and reinstalled Ninox and it still won't open. Is there something else I can do to get it working?
-
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
-
generate PNG invoice files?
Can Ninox directly convert PDF to PNG and other image files? Or generate PNG invoice files? If so, how to write the code? Thank you for your reply.
-
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
-
print view
How can I print view without subtable
-
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),…
-
Trigger after update & Alert anomaly
Community - I developed a database in the Mac app. The database is deployed on the web. There are 2 fields in a table that have code entered into the 'Trigger after update field'.…
-
join with conditions
i want a formula where i join a table to a text file, this i allready got working, but i want a condition where in the table i line is called "eis" i want a text with all the line with "eis" and a…
-
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
-
Duplicar archivo
Buenas tardes, al darle a duplicar archivo te tienes que salir de la base y meterte para verlo. Me pasa desde hoy. Tengo archivos que duplico y edito pocas cosas pero ahora sale mal.
-
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
-
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,…