How to link add data with a button click

Hello, I have this formula let p := (create Renovaciones);p.(Temporada := "2018-2019"); that let me add the p. to the table Renovaciones. In Renovaciones I have a box for the current user linked.…

How to calc sum of date specific entries in one table from another

Hi, I’m new to Ninox, having come from HanDBase for iOS (which I found had a simpler method of calculation). I’m trying to create a table that summarises entries in another table for a given date.…

Can you place the "€" signs left in a tabel and the amount on te right in printing mode?

I would like to print invoices. I juse a table to include al the products. The position of € is based on how much digites the amount is. Can I chande this by lining the € sign to the left of the…

Trigger on Drop down Choice does not work

Hi, I am trying a trigger from a Choice Combobox field but it does not work concept := if Classification = "Concept" thentext("true")elsetext("false")end Any advice? Thanks

Trigger based on multiple fields

Hi, I am trying to trigger based on inputs from multiple fields, this is my effort - any advice? country := if CHINA = 1 and EU = 0 and GB = 0 and US = 0 thentext("true")elsetext("false")end

If Statement between dates

I am trying to figure out a formula to give a value using the If statement but am struggling to make it work. I need something like this: if 'datefield' >= '01 Aug 2016' and <= '31 Jul 2017' then…

How do I delete a database?

Thanks.

Control to view web page?

Is there a field type or way to display a web page in a form? For example, if you have a customer database and want to display their home page in the form, to have an embedded web view, of course,…

choice list

choice list

Waiting Trigger

Is it possible to make a timer so that whenever something is true for example, an Alert() pops up every 10 seconds untill that something is set back as false?…

Database look up

Is it possible to look up a table in a different database? Thanks

Display chart

Hello, I have a list of dates but want to show volumes of activity in a month. I have managed to create the format of the date by using format('Start Date', "MMM,…

Command F

other pcs wont find the "server"

Had to reinstall windows on the pc used for ninoxdb and localhost:8080 works ok but the other pcs wont see it

HTTP calls - client vs server context

I am wondering if there is a way to force http calls exclusively from the client context. I have tried to use do as client but that is automaticly changed to do as server The reason it needs to be…

Ability to Change Button Color in if result alerts

Is there a way to change the color to the result alerts? For example: Do you want to clear all fields? "red(Yes)","no" Is it possible to change the results colors?

Filter view

I have a view that is looking up data using let u := ULN;select 'Indicative Earnings' where 'Unique learner number' = u This produces: What I want is for the select field ILR Year to filter records…

in ninox cloud is possible to set permissions so invited users cannot edit, create or delete fields

in ninox cloud is possible to set permissions so invited users cannot edit, create or delete fields

Would like to use a field in a table ...

Would like to use a field in a table as a value in a Choice field. The table will be maintained away from the form.

Number format using £

if I am displaying a negative amount in British Pounds then it displays as £-20.00. I believe this is incorrect and should read -£20.00. I am not sure whether or not this affects other currencies?…

text dialog on two rows

It's possible to display the dialog/alert text on two/more rows?

Embedded charts and views

Has anyone manage to wright a formula to show charts and wiews in a form? Nick

chart "Display field only if"

I am trying to use the "Display field only if" with a chart, but can't seem to get it to work. The chart always displays. A record can have a multiple links to records in the "Sensor" table.…

All data has duplicates

how do I remove the duplicates?