How to use Date, Start time and time interval Field

Hi all, I'm having problems working out how create an appointment based on a date, start time and time interval. For example. I would like to book in a meeting by putting in the date,…

Dynamic Choice Field text (Value) vs Number - Where can I find them?

I have an excel with Country, Region,District I import this to my GEO table. Then I have a DCF in my MAIN table that show all Countries and I pick what I want.…

Form

How can I disable the resizing form ?

Merging RTF Fields

Is there a way to merge RTF text fields into another RTF text field and maintain formatting? When I merge RTF fields I get one large text paragraph with all CR's removed.

• Answered

In Forms, search for string only returns one record

When I search for a record in a form, the search string is either not found or only one record is shown when the string should be found in multiple records.…

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?

Appointment Scheduling Software Help

Hallo i have a patient database in Ninox, i kindly ask if someone have integrate Ninox with an Appointment Scheduling Software. My needs are to have an Agenda that can choose patients from my…

Balance

Dear all, I'm new in using ninox and i'm trying to set up a database to trace my income and expenses. I'd be grateful if someone could help me for a formula that can give me the balance every time I…

Convert table to subtable

I would like to turn a table (B) into a subtable of Table A. Table B provides reference to A already. Many thanks in advance.

• Answered

Can I restrict the share view to specific set of users?

When we activate share view, is there anyway we can restrict view to specific set of users and not make it public ? Also charts view is not seen as chart, it is seen in form of tables.

• Answered

Chart maps null data points a value of "0"

When a chart is drawn and it contains null data points, the null data points are displayed as having the value of "0" In the chart below, all of the data points at zero are actually null.…

Link to locally stored video file

I have built an asset manager for all my footages since several decades. One field contains a picture, generated from the video. As that particular picture is embedded,…

Formula openFullscreen

openFullscreen(openTable("Tablero Avances", "Dashboard")) There are any problem with theses Formula. Sometimes open the table and other the form, I need always open the form, need something more.

Copy text for subtable and paste in textfield in main table

Hello everyone, I have problem that I cannot resolve by myself. I am a physician and I am trying to develop this database to help my patients to get information.…

Formula for Chart Line

I need a Chart Curve for the two columns %Plan vs %Real in the Form view How can I do that.

• Answered