Relative record numbers in a table

I want to grab a subset of a table. Then display the subset in a view and have the view numbered from 1 to the count of records in the view. In other words,…

• Answered

Hiding new icons etc.

With the launch of 13.3 (very nice indeed) this script needs a little tweaking because it does not hide the new 'Edit mode' toggle. Can anyone rectify this? I don't have a clue :-).…

A quick TIP re buttons and field formats with 3.13

I was under the impression one could save a 'style' for a button and simply paste it to each in turn. If you can please advise how but here is a work around if you cannot.…

Dynamische Drucklayout - conditional line breaks

Hallo Zusammen, ich mache ein dynamisches Drucklayout und muss Zeilenumbrüche aufgrund von Inhalten machen. Es ist mir klar, dass dies auch via Script geht, ich würde es aber gerne im Template können.…

Please check this email script

Can someone scan this to see if there is any reason why the email suddenly stopped going to me. I have added a comment at the end of a line to show what I changed.…

Complex criteria for Select

Hi, I am working on a project which requires a dynamic choice field to be populated by the results of a select based on one or more of four criteria. The criteria are selected at the top of a…

• Answered

Stopped working for me

if s2 then let reply := dialog(" M A J O R - Non Conformities", "This Audit was not compliant. Therefore, major non-conformities will be reviewed within 14 days. Include new Audit Time.…

• Answered

Record reference numbers

I would like to have a reference number for each of my records that follows onto the next record. for example my first record is 0001 and I would like the next record to automatically be 0002 and so…

Ninox http Request broken; maybe during update?

Hi there, just wanted to create a CRM trigger in my Ninox; that's basically an http call towards an n8n instance. It was built long ago and I didn't change it.…

Add/Insert record on button click

@Fred Hello, I am trying to create a new record on button click, however it is not able to find the specified column in the target table. Am I missing something?…

• Answered

Tabellenspalten in Ansicht mit Bezug auf Feld des Datensatzes, wo die Ansicht angezeigt wird, konfigurieren

Hallo, gibt es eine Möglichkeit eine Tabellenspalte in einer Ansicht (von einer anderen Tabelle) mit Bezug auf ein Feld des Datensatzes wo die Ansicht angezeigt wird zu konfigurieren?…

Query regarding View Element

@Fred Hello, I was going through your post " https://forum.ninox.com/t/g9hbyt2/pass-current-viewing-record-id-to-a-view-element-column-formula " as my query is also almost the same,…

• Answered

Ninox forgetting entries

Hello Forum. I am a new user. I have setup a databass that works pretty well but I have noticed that from time to time, Ninox forgets entries within records.…

Date field does not remain empty

I have a few date fields that don't remain empty after I clear them. Mac app 3.12.4 Only certain records show the behavior. I clear the date and exit the database.…

using Choice in formula tab when trying to create a dashboard

when I try to use choice function in formula tab it comes up with an error. I have used the feature before but for some reason its no longer appearing when typing choice

Can't calculate the GST and Balance Pmt formula fields

Hello Friends@Fred@Mel Charles , I can't wrap my head around this problem. I have four formula fields on the form 1. OrderCharges, 2. OrderTotal, 3. GST, 4.…

Styled number field maintaining it numerical?

I know we can use this: styled(text, colour, icon) To change the background and icon for a given field. The problem comes when you have a calculation, say “TOTAL”,…

Alternative to SendEMail - Calling local email client

So - I have been using SendEmail for several years now and by and large it does a good job and I have some great styled forms that are sent out as wwell as using it for auto mailing clients etc and…

print command in html()

Hello. Is it possible to trigger the print command embedded in html() for example by onclick=ui.printRecord('{ me }', 'all')? Greetings Mirko

Change a field alignment in script

@Fred@Mel Charles@Sean Hello friends, I can't figure this thing out. Is it possible to change the alignment of a formula field to right aligned inside a script without using HTML,…

• Answered

Query regarding the sale price per item in Sale Order

Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…

• Answered

How to maintain rates in old transactions

@Sean@Fred@Sotirios Zormpas Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…

SendEmail function not working

Code has been working as of a few days ago all SendEmail functions that worked now returning with this error

urlOf(this) won't work in iPhone App

I have been using the function urlOf(this) to return the URL of the current record so that I can email it to a user who will need to login and update this record.…

Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Hi, I'm new to Ninox. I am trying to build a system that counts the number of each day of the week in each month. Example: July 2024 Mondays: 5 Tuesdays: 5 Wednesdays: 5 Thursdays: 4 Fridays:…