Ignore hyphens when sorting

I have a list and am sorting by a reference number. The reference numbers have two formats, AB-C-01 and ABC02. Some have hyphens and some don't. With or without hypens, each reference is unique.…

How can I recover lost data???

Yesterday we lost 1800 records from my data base, and I am afraid that it's because we recently paid our data plain and it's not reflected in my app

ExtractX help!

Hello everyone! From this RAW text, I need to extract 2 timestamps (in 2 separated formula fields) for the patterns: q101_agendaCita q126_agenda126: {"slug":"submit\/221023934014341\/",…

Converting an input to an output

I have three input fields: Watts Input BTU Input Temp Input The Output field is: BTU OUTPUT In the case of Watts Input - BTU OUTPUT is Watts Input * 3.…

Script permission attribute

Hi Ninox users, There is a way to run a script with different permissions than the current user? thanks !

I Made A Wrong Payment and Ask For Return My Money Back

I Made A Wrong Payment and Ask For Return My Money Back, I double buy licenses, please return my money back.

• Answered

Syntax create record

Hi, i know a sintax for creating a record : sample : let p := create Person; p.Name :="myName"; ok nice, but i have one time see a other syntax for creating a record.…

How to delete/rename a table in web and on iPad?

Obviously I am new here and this seems so baisc. But the truth is, I cannot figure out how to delete a table in web view and/or on iPad.

Switching to next year

Hello everyone, I hope you're all well! I don't know if this question is already asked, but here's the deal: I have a table containing 2 fields-1 text field and 1 date field.…

Dimensioni campo formula

Salve, è possibile dimensionare un campo formula con le dimensioni scelte a piacere. Ho un campo formula con un orario. Ho bisogno che se seleziona 1 ora abbia una dimensione,…

Data Entry Validation?

What is the preferred method to validate (restrict) user input? Say you have an "ounces" field that should only accept values from 1-16. How would you enforce that data entry? Thanks.

Set another field's value from calculation?

Is it possible to set another field's value (in the same table) from a calculation? I haven't been able to do it. The calculation would also set its own field's value.…

How to get max value + another column?

I have column for my pet and another column for his weight I'm trying to create a computed field that has both the "max" weight and the date that that weight occurred.…

Help

Im trying to create a data base of customers where i sell a service to a customer and it creates an invoice etc. any suggestions as i am not getting anywhere fast.…

Include field content in Formula acting as a button.

A typical example would be a formula acting as a button when adding contacts where the persons name is added so that a formula/button would be: Add John Doe as a new contact.…

• Answered

Create JSON file for line items

Hi there, I want to send my invoice data to a third party accounting tool. Therefore, I want to iterate my Ninox invoice line items, transform them to JSON and send the JSON via REST API to the other…

Understanding file attachment strategies

I have a few use cases that involve managing inventory items - like my photography and RV equipment. I want to link a variable number of pdf/photos/other (e.g.…

Will Ninox (if it doesn't already) support general purpose scripts?

Is it possible to automate workflows in Ninox like importing a file, doing some calculations, and exporting the updated table back out?

Scanner for Ninox on the cloud

I am looking for a WiFi scanner that could interface with a Ninox database on the server. I want to be able to use a handheld scanner that can scan a QR code and do the following:…

Fix 0 Value on Line Curve Graph

How to Fix these problem with the Graph Curve ? The green curve no 0 values

Delete multiple records?

Say I do a search and want to delete those "found" records? How do I do that? Also, say I just want to empty a table but not delete it. How is that done? Thanks,

Pull records from a chain of related records.

Given: Customer (Table) Name (Field) Item (Table) Brand (Table) Sales (Table) Sales Subtable (Composite Table) Table Relationship: Customer -> Sales <- Sales Subtable <- Item <- Brand Objective:…