Hyperlink in PDF

I am trying to set up in a layout a hyperlink It is defined in an included table column formula. A first result is obtained by simply displaying the content of a URL field: https://drive.google.…

header in HTTP function response

Hi, Is there a way to get headers values of a "http" function response ? I need to know the value of a specific header in the response sent by an app when I send a http request.

multilevel bullet list

Hi, what is the trick to format a multilevel bullet list in a textarea. Just using tab on the keyboard seems not to work to get a second level in a bullet list.…

Create a new record from a table directed to a specific TAB

This script works just fine but I cannot figure out how I can to add a TAB name in the script so the table/form opens to that TAB. The TAB name is INPUT.…

Print Charts?

How can a chart be printed?

ANOTACION EN PDF

Hola, soy nuevo y poco a poco voy creando mi base de control de obras, he visto que la nueva actualización incluye PREVISUALIZACION Y ANOTACIONES EN PDF,…

• Answered

Running number issue

Hello everyone. I've setup running numbers for our stock, invoices etc. That does work as intended. However, if any previous record is deleted, the next number created will be a duplicate.…

• Answered

If user has email.....

Darn I cannot find/forgot :-(. How does one stipulate that a table can only be opened by a specific email address or name?

Filter an array based on a Multichoice using another Multichoice

So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…

• Answered

chartanalyses

Hello - i have different historic data in my database K(n,t) n index of the chart data; t dates and want to analyse them statistically. That means i have to calculate formulas that are depending on…

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

Formula with calculation between two different times

I want to make a different text for each hour, and then make the text coloured red when the hour (now) is in between a chosen time. What is wrong with this example? Example: if time(now()) > time(9.…

How do make a record creation step precompile a table with "Link from?"

I have a table that contains all the replacement parts used on the machines so that when I go to view the machine from the machine log you can see all the replacement parts used on that machine over…

Insert a line break in mailto body

Hi All, I am using an email field where in the body I have alot of IF statements. Below is an example of an IF statement {if 'Is PPC to be included in report' then 'Google Data Studio Link' + " TEST…

How to export whole database

how do I export all fields; when I chose export, only the first few fields are exported; I can't see a way to set it to export all fields

Search in formula field

Hi colleagues, I have a table that consists of 3 different text fields (lets say A,B,C). These fields are joint in a separate formula field to show them concatenated, too:…

Locale backup has no data

Hello, when I download a backup and click on import archive locally on my Mac Ninox Database App, the locale backup has no data. Everything else seems to work, but the tables are all empty.

• Answered

Is it possible to split the Location field to several address formula fields in Ninox?

I want the Location filed to split and copy the address to several fields like Street, ZIP, City etc, is that possible?

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

Show form of combined select (or array) logic

Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…

• Answered

Switch with multiple for loops and consequents new records

Hello, for each person, I need to list all the academic years that person has been or is being hired, along with the startDate and endDate for each academic year resulting.…

Pulling data from Power BI???

I am a complete rookie when it comes to all of this but I've done my best to learn as I go. One of the main things I would like to be able to accomplish is this:…

Splitting data or trimming where a space is

Could someone please tell me how to remove all text prior to a space? I have a column "Colour" and the data is presented as "Clear 3mm", "Clear 4.5mm", " Lemon Grass 3mm" etc I'd like to be able to…