Dynamic Choice Field Assistance

I am having some trouble with a dynamic field: let ths := this; let thisUserDepartment := ths.Department.Id; let thisUserTitle := ths.'Job Title'.Id; (select 'WFM Permissions' where numbers('Eligible…

• Answered

Send email and include only fields with value

Hello. I do want to send service reports to customers. I have a code which works fine (see below) but I would like to exclude fields from the text in the body of the email,…

Field border colours missing

This has been happening for a while - I don't know what changed, but on MacOs I have lost all the field border colours, making it very difficult to see what's on a pop-up, or forms on a field.…

Proper Case code sample

It seems Ninox does not have a proper case function. That is to say only the first letter of a sentence to be forced to Upper. The best I could come up with is: DESCRIPTION :…

Tables sync

Hello everyone, I have the following problem: I have a Table A with X and Y fields and a Table B with links of X and Y fields. If I choose a value on the link X on Table B then the link to Y field…

• Answered

auto populate email field

Hi guys Is there a way to automatically populate an email field with the mailadres from a person from a linked table? In this scenario I don't want to use the Formula-field because this formula field…

Structural Problem - How to choose multiple items to add to an Invoice?

I have Appointments. Each Appointment has multiple Invoice Items (since Appointments are only ever invoiced once, they double as the invoice). Available Items to add as Invoice Items come from a…

Paperclip TAB for attachments - crazy idea

Seems to me the Attachment Tab is indeed a rather special TAB. So just for fun I tried to drag a formula onto the Paperclip Tab. It created a formula on a new TAB automatically.…

Copy contents of reference link to another field.

Hello. The "Select" field you see in the screenshot is a "Link to" reference. My intention is that whatever is selected, should be copied over to the "Description" field (text field).…

• Answered

Server slowdowns !?

Am I the only one with big server slowdowns this morning ?

Determine if linked record's Multiple Choice contains value from this record's Choice field

This record has a Choice field with two values: Cat, Dog and this record (obviously) can only be one or the other. This record has a linked Colouring table where each record has a Colour (text) and a…

Sub table To a tab

I have a sub table on a 'contacts' page which shows me a list of booked appointments for that contact. I want to move this sub-table to a tab - is this possible?

Current Storage Capacity

Hello and congratulations on this FANTASTIC, USER FRIENDLY database. I checked one of my records this morning and realise that it was missing its attachments.…

• Answered

Justification - top/bottom, right/left, center/center

I am still thrashing about in the underbrush sometimes. I've got a small database to organize plant information (seeds, cuttings, when to plant, etc). I'm using a local version of Ninox--I'd tell…

Hide Multiple fields at once

Hi, I know we can hide individual fields by going to Display field only, if & entering "null". I have say 10 fields that I want to hide. For that to happen,…

• Answered

Minimum value 'number'

if not 'Number 1' then 'Number 1' := 'Number 4'; Formula gives value for 'number 4', after that I have the opportunity to change it if necessary. But I can't give it a value 0,…

• Answered

Multiple forms for a table?

It seems like any given table can have multiple forms created for it, however, when I do that I don't see any fields on the form. Changing the Edit columns... makes no difference.…

Check if 7 fields have been filled

Hi! In a table there are 7 fields to fill and 1 button. The button serves to create a record in a linked table, on this I have no problems. I would like the button script first to verify that all 7…

• Answered

Line feed/Carriage return in an Alert

Is this possible? Rather than The quick brown fox jumped ove the lazy dog One could format as The quick brown fox jumped over the Lazy dog TIA

In Out Button

Ш need to create a table where the in/Out of goods will be marked. Access to the table will be closed and the record can be done through the button. There will be two In and Out formula for In button:…