-
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
-
acces to array items like with Where fonction
Hello to all, This new forum made me want to share something with you . I chose this code which allows to find elements in a table by filtering as we would do with the Where function of Select.…
-
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:…
-
Help with Scripting
Hi, I am trying to add logic to a function that I created that will flip the item status from listed to sold, donated, returned, etc. I would like to put in a safety piece that will prevent this…
- Answered
-
Pass current viewing record Id to a view element column formula
Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
-
Question new functions
Found some new functions in the .js files. Anyone knows what these functions do? createTempFile(string,string) and appendTempFile(string,string) or are these not yet implemented?
-
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 ?…
-
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?
-
Adding values between values in a (dynamic) choice field...
Ever wanted to add a value between values in a choice field? This is possible with a Dynamic Choice Field : >Formula in the MoveUp button: Number := Number - 1.…
-
Has anyone wanted to hide the add new record button on the popup link?
simply add a formula with CSS and add the following .stringeditor-button2 {display: none;}
-
Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.
In this database you can fill order lines with Dynamic Multiple Choice Fields and Cascading Choice Fields. It is located in the EN Team webinar and is called Cascading DCFields. Steven
-
Fonts, Colors and Borders
Hello, I uploaded an interactive CSS generator database titled "Theme Helper" in the Webinar EN 2021 team. It is very slow to respond online in the browser,…
-
Accessing a single line item on an invoice
I'm trying to pull the TOTAL value of a single line item in an invoice that has 3 line items consisting of £195, £56, and £18. After trying everything I can think of,…
-
Order by descending
When selecting records you can't specify descending?
-
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.…
-
extractx() “g” flag workaround
Here is a basic UDF for extracting all of the values that match a regex pattern... function extractxg(src : text,regex : text) do let extValue := “”; let idx := 0; let idxLen := 0; while testx(src,…
-
print Ordered
i have: if text(InvoiceItemVendor.'Status Item') = "Ordered" then printRecord(this, "Ordered") end but it doesn't work
-
Removing duplicate fields (emails as example) solution
for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!=1 do delete last(select Table_Name where Email_field = text(i)) end end Enjoy!
-
html() function
I uploaded a database named HTML Tricks. So far it only has one example, but I've got some other ideas I've been playing with. If you are interested in a blinking formula field you should give this…