print

is there a way to print by word or excel office directly? not pdf, export to word or excel?

• Answered

Formula Problem.

Hi I need That if Horas Ganadas Real is = 0 then Horas Actuales is = 0 too. The Horas Actuales is a Formula let t := this; sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales')

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

Formula with a value of the last record

First of all excuse me for my poor english. Let's se if I make any sense. I have a field of total in a record of a day and want that same field start as a balance on the next day i tried to use this…

ID of a newly (Create 'table name')

How can I extract the ID of the new record created by: let i := (create 'table name');

• Answered

if, then not working within a function field script.

The following is code in a field. I want to have the field contain one value if a dynamic dropdown 1 is not empty and another if it is. I store the record ID of records in table A in field BPID1 and…

monthName Format

Hi I would like to return "Jan" instead of January when using the "monthName" function. Any tips?

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

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