-
Double Search
I have a double search formula ( Name & Format) let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray :…
- Answered
-
How do you give a Yes/No field in Chart text names instead of 1/No
I've created a Chart where there is a Yes/No field called PAID where I want to show the Data separated depending on if it is a Yes or a No. However on the Chart is shows up as a 1 or the work No so…
- Answered
-
Questions about code merging.
In the following database, "1" is based on "Data1" to calculate the current state; "2" is based on "Data2" to calculate the current state. I want them to merge and be displayed in "3",…
- Answered
-
Questions about printing invoices
In the database table "Orders", there is a "New document" button. I created a new "test" table and set a "pdf" button. I have an idea that clicking the "pdf" button will generate a "pdf" of the…
- Answered
-
For the question of using N:1 search
When searching for the same content in the same database, there is data returned on the MAC port, but no data is returned on the web port. how are the search keywords defined?
- Answered
-
Regarding the batch write issue.
I created a button to change existing data, but when I click the button, the returned data is always the same. I have tried this many times, but I can't find a solution. I am asking for your help.…
- Answered
-
calendar option missing
I have Ninox Mac version 3.10.10 and my system is MacOS Sonoma 14.2. I have a MacBook Pro 2020. I unistalled Ninox from my iPad and iPhone, I have been working with this 3 devices and I have data…
- Answered
-
Verify working time
@Fred Is there a way to verify that a Staff working on two o more Documents does not Spend more than 40 hours. ?
- Answered
-
Help with a search
I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…
- Answered
-
button for Duplicate a record and its links to a sub table
Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…
- Answered
-
Coding a popup dialog in a for loop if error
I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…
- Answered
-
Prohibit Deletion
I Heve a task that will prohibit deleting tables and records, APP mac. Found how to hide the delete icon in the bar html(" <style>" + if not HUD then ".i-setting-print{display:none;}" end + " .…
- Answered
-
What does this mean?
I have no idea what this alert is trying to tell me. Far less how to fix it. Can anyone give me a clue?! Thank you
- Answered
-
Problem with dynamic report
Hello to the community, Hello everyone, I have a problem with dynamic reports. I created a word document with the tags but my mac application crashes every time I try to test printing.…
- Answered
-
openTable() with sort order.
Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…
- Answered
-
Getting pdf file from the API response
Hello API experts! I would appreciate your help saving/opening a PDF file, which is the response to an API call. This is the code of the API endpoint call inside a button: let url := "https://testeps.…
- Answered
-
Account flows
In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…
- Answered
-
Lead Scoring Assistance
I need some help creating a formula to build Lead Scoring. I have created a formular field in all Lead Records called Engagement Score. I want it to build a score based on their status value with…
- Answered
-
Constraints issue
In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…
- Answered
-
Alert not working
I have a formula that looks for duplicate records and if it finds one or more than it should bring back an alert. Not working anymore. Any suggestions? let xLast := 'Last Name'; let xFirst :…
- Answered
-
Export .csv to excel not work
https://youtu.be/Eo6WUmG86fE The Scrip on formula is: let me := this; --- GENERAR COMBINACION FILTRO ---; let myCon := ""; myCon := myCon + if Alpha then "X" else "_" end; myCon :…
- Answered
-
Is there a known problem with dynamic printing?
In the last couple of days, all my attempts to dynamic print failed. Even if I try to print a blank page, I continually get an error message! Does anyone else face the same problem?
- Answered
-
Convert XML API call response into JSON object.
Hi, after a successful call to a public API, the response that I get is of the following form:…
- Answered
-
Lost something here
- Answered
-
Using triggers for yes/no field
I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…
- Answered
Answer questions and share your knowledge