-
How to action a trigger after form close?
Hi, am wondering how can i action the update trigger after i close the edit window? What is happening it keeps on sending numerous notifications on every field i update which is cumbersome.…
-
print Ordered
i have: if text(InvoiceItemVendor.'Status Item') = "Ordered" then printRecord(this, "Ordered") end but it doesn't work
-
How to query a table using a dynamic combo box value?
I have the code below, i want to return the email address where the the full name of the staff is the one assigned to the ticket. let i := 'Assigned To';…
- Answered
-
how trasform a time interval into a number?
How can I calculate the cost of a working day by multiplying the number of hours worked by the hourly price?
-
Dynamic choice field to autofill text field with values from unrelated table
Hi all, I’ve searched the forum but haven’t found any specific thread so I start this new one. I always used FileMaker Pro (never been a pro user, anyway) and just moved to Ninox so bear with me and…
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
Seek help to find array position number in a array loop
Hello, This is my first post, so please bear with me if the formatting and my wording dont make senese.... I am creating a genealogy database just for the fun of it,…
-
Character Occurrences Count
Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…
- Answered
-
Search view Formula don't work
I Have these Formula for search Ganado Plan but don't work any idea. let Busqueda := Busqueda; select Documentos where 'Ganado PLAN' = " " = Busqueda
- Answered
-
Finding the sum of the last entry given specific text in a field
Sorry for the nonsensical title. I have a table called Bulk Inventory: In a formula in a different table, I want to find the sum of the 'Cumulative (Laa)' values for the final entry of a given month…
- Answered
-
sunrise and sunset
Would any of you who live in a different time zone than CET be kind enough to test my script? It displays the sunrise and sunset at the site. The accuracy is about two minutes.…
-
Auto populate fields with the value from the previous record?
Hi I'm only new to Ninox and setting a database to suit our business. Is it possible to auto populate fields with the value from the previous record? This was a very handy feature in Filemaker.…
-
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
- Answered
-
Button in table x (subscription) to create a record in table y (Deliveries) and its subtable y2 (Delivery lines)
Hey so we work with a subscription formula so the products the customer gets is preset in fields in table x (max8). I want to create a button in table x where when you click it you create a record…
-
Set Choice Value
Hello, I am creating a button to set a value of Box1 to 'Active' (id1). How do I set the choice value of clicking the button instead of: Box1 := 1 I tried: Box1 := text("Active") Box1 := "Active:…
- Answered
-
Export Import File
Hi, I need to produce a file that has references to the same record but on multiple lines. It is for an import file into our web software. The file is:…
-
Message - Improvement
Heres a thing... As these days I work mainly from home - I have a reminder that if appropriate! sends and email to my team at the office when I log into Ninox.…
- Answered
-
Why urlOf(This) doesn't lauch the App ?
Hi, Would it be nice if the urlOf(this) links used on a mobile device, on Google i.e., would lauch the Ninox App (if installed) instead of opening the browser interface ?…