how to export a file attachment

hello, i want to create a button to export a pdf file, created by printandsaverecord, in a external(https://www.....) location. This in order to use this file in the mailing to the client in another…

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

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.

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'.…

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

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).…

Manual sorting view?

Is there a manual sorting view? One that stays the same until you drag and drop records up/down? If not that's feature request.

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

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';…

print view

How can I print view without subtable

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.

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…

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

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

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