-
Badges on TABS
@Jacques TUR and others. Using Ninext is it possible to add a badge to a TAB? In the screenshot below you can see I have a TAB to view the notes related to a particular Location.…
-
Export/change/import attachments
Hi gurus, In our DB, we have a huge number of attachments, some of which can be of reducible size. Is there a way to access directly the attachments, in order to reduce their size (pdf, photos) ?…
-
Different results using Checkbox vs Button to update text field with today() using the exact same code
I was having an issue with dates not storing correctly with some of my code. The code was storing dates as the next day instead of current day. While trying to figure out where my problems were…
-
Beginner's question
This is so simple and basic I'm almost embarrassed to ask. I have a recipe database one of whose fields is 'Ethnicity', with various options (Chinese, Italian, Greek, etc.).…
- Answered
-
Setting a color for a TAB - Ninext
@Jacques TUR I have this on a TAB in Display if: which works perfectly, function onUpdate(event : any) do { caption: "LOCATION NOTES", color: "#fcfcfc", backgroundColor: "#ff3333", tooltip:…
- Answered
-
Bigger images in print-layout
Is there a way to make the images in the upper right corner bigger? My aim would be to have larger thumbnails, with the title below each image. At the moment the images are decidedly too small and…
-
Targeted deletion of records in tables
Table management is an important task in keeping your database clean and running by avoiding redundancies, accidental double entries, etc. While you could open every record in question and delete…
-
Dynamic choice from Multiple choice field
Hi there! So I've been browsing on possible solutions but so far nothing that I can understand exactly or addapt it to my case (newbie here!). I'm trying to code a dC field to retrieve the selections…
-
Avoid spaces in a sum function when a variable is empty/void
Hello, the product name in my products database is a sum of 9 text and number fields, like this article + " " + Color + " " + more stuffs + " " +kg + " " lt" it works for normal use but in print view,…
- Answered
-
Link multiple records to a parent record
Hi everyone. I develop a database for creating a schedule for trainings. I have table with clients' applications for trainings and a table with training groups dates.…
-
"Join" script function will not show line breaks
I've just started using Ninox. I've set up a database for my contacts with it. The database has two tables: "Contacts" and "Organisations". Contact details that are specific to individuals (eg,…
-
Parse a specific section of a YouTube URL
How would one parse out this section of a YouTube URL Complete URL = https://www.youtube.com/watch?v=BbqlkY0ArfM I want just this portion: v=BbqlkY0ArfM This can then be used to watch a video from…
-
Field/formula alignment issue ver 3.8.1.0
Last night I noticed this: Note the two green fields and the Locked check box. This happened last night and occurs across the DB so is not isolated to this form.…
-
How to get filtering to work in a reference field that is set to popup and has columns from linked tables.
Don't know if anyone else needs this but for some reason it has taken me way too long to finally figure out why I couldn't filter a reference field that had columns that showed linked data.…
-
How to create a field that displays all gigs worked within a range of dates?
I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…
-
List field content using rsort()
I'm trying to print a list of all entries in a given field between two specified dates. With the precious help of other posts in this forum I managed to get the list but it still brings up all the…
-
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Answered
-
Parent / Child / Grandchild
Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…
- Answered
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
conditional unique() in column
my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…
- Answered
-
Automated Multiple Choice: Is it possible?
Is it possible to automate Multiple Choice field based on trigger/update from another fields – which is two or more fields. See situation below: Multiple Choice (MC):…
- Answered
-
How to style a numeric fields?
Good morning! I've had issues with the styled() function these days and after having read several articles in the forum: it seems that the stlyed() function converts the variable to text.…
-
Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- Answered
-
Print Dashboard
Hello! I created this dashboard and I love it but I can't find a way to print it. I own a bakery and this is for the delivery orders. The tables below are views.…
-
Order by date from text field
Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that?…
- Answered