Fields and Elements

Auto-increment?

Is there currently an auto-increment field of some type? If not, is there a way in code? (I found some old posts, so I don't know how relevant they are anymore,…

Hash of a string and check

Hello everyone. I use SHA-256 algorithm to generate hash from strings. Hashing is generated correctly and the value is copied to the clipboard. function sha256HashAndCopyToClipboard(string :…

• Answered

Video Field versus Image Field

Is there a field for importing a video into a database that can later be played on demand? - John

Populate text field based on selected option from a DCF

Hello @Fred@Sean I am trying to populate the email field based on the selected contact person option from the Dynamic Choice Field on the Sale Order form.…

• Answered

Data in the OrderItems table changes on its own

Hello, I just noticed a weird think happening to my database. Today I was working on the CRM database in the office where I work in the cloud version (since they have windows OS).…

Change order of records in Kanban

Hello, Ninoxians! I have a Kanban for leads with several statuses: new lead, attempted contact, contacted, hot lead, booked, etc. Whenever a new record is added to one of these statuses,…

Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated! I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field.…

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

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

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

Ninox cannot fix email issue

Any send email function does not work. Over the past few months inconsistent operation of email function. Multiple requests fix issue but then only works for a day.…

Assign a sound to a formula button

Hi to all! Thanx to @RoSoft_Steven (who created this post: https://forum.ninox.com/t/35y3lcz , I am using custom buttons. In my record, I created an embed of a small player that plays an mp3 file…

What is the max number of characters that a text field can be defined to hold?

I am using Ninox stand alone - no need to sync to the cloud for my purposes. I have a d=table that includes a text field, but have found I cannot add as much as I had hoped to - is there a maximum…

How to disable Create Record button in reference

Hi, This topic was brought up 4 years ago and was closed with a reply about the cloud version of Ninox, however there was no solution suggested for the local Mac app version of Ninox.…

Using SNAGIT for tutorials

Hi, I use SNAGIT and it occurred to me that it could be a useful way to create user video tutorials. SNAGIT allows one to create a video and then share it via various methods such as Screencast which…

Sudden change in screen layout.

I don't have a version update as far as I can see - 3.12.7 is what I have now but this morning when I loaded my APP everything is messed up UI wise. Anyone else have this happen or do I need to…

Argument with Ninox AI and reference field

Hi, I'm new to Ninox and the AI option is just an amazing lifeline I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached…

(JSON) Object parser Browser vs. Client

I am despairing of what I would call a bug. I have a function (global) that works fine in the browser, but fails in the app and breaks the entire global script.…

• Answered

loop in query for view -- how to aggregate?

I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…

Populate a field with values from a list

Hello! I need to write some values in a field. There are around 10 different values, that i want to put in a field in random order. I guess i first need to put them in a separate table,…

Formulae in Global Search

@Jacques TUR Is it at all possible to work your magic so that based on user wishes formula fields can be excluded from the view that result from a global search? Example:…

An idea for a Ninext tweak.

@Jacques TUR Would this be possible? To have a tooltip concept when hovering over a cell that displays the full content of that cell. This could be handy where cell width is reduced,…

• Answered