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

Paste Excel cell intor RTF field with simple HTML

Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…

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

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:…

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

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