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

Clear Code for Button?

What is the function and code to use in a Button to clear a field? I want to click a button to clear two search fields.

extractx problem

no experience with regex Need to use extractx If anyone can help, would be greatly appreciated! text field = textA - textB would like to put textA into one field and textB into another field…

• Answered

Auto-populate a predetermined Number in a field depending on a choice made in a combo-box

How do I Auto populate a predetermined number in a field that will change depending on what I choose in a different combo-box. ie. Combo-box has these options 1. Purple Sweater 2. Pink Sweater 3.…

Multiple invoices for the same item

Hello All, This is my first post. The forum as been helpful and great to follow. I’m at loss for this scenario and would appreciate some help. Is it possible by formula to generate multiple invoices…

Formalae for Summing products selected

Hi All, I currently have a Multiple choice field (Show as Radio Buttons) where the staff can select multiple products that the clients has chosen to Purchase.…

Unique Field in a table

sorry but I didnt fund it in the documentation... my bad probably How can I force a field in a table to be unique? eg a field that is used in a N:1 table relationship...…

sum( where) help needed

I have a table named "Tax" which has a single user entered field named "Year" and then a number of formula fields that are supposed to collect data from other tables (Invoices,…

Save trial database work to my recently purchased Local Mac Ninox environment.

I created a trial cloud database, imported some data from a csv, but now I purchase app for my mac. I want to move the data from the cloud trial to my local system. How do I do this?