End Expected

I have the following code in Table Level, at trigger after update, but im getting End Expected: if at line 9, column 2 (Im an absolutely newbie to coding) let a := record(Marketplace,…

When you sum a column how can you set decimal place for the sum value

Cant record

Cant create any new records, i tryed in samsung tab s7, samsung S21 and pc

Format number as currency

Hi How do I set a field as a curency field? I still want to be able to show totals, etc. - so I guess I want this as an underyling number. I just want it shown with the correct currency symbol.…

Import into table with Multiple Choice (Dynamic) field/column

I have the MC(D) working, but need to import a lot of records into the table. They currently exist in a spreadsheet with that column already filled with the correct data,…

Forum search bug

The forum search seems to give a 404 if I search with some terms. For example, if I search for the word "Authorization", I get a 404 error. https://ninox.…

HTTP GET Calls with Headers

Hi I'm really struggling with making HTTP GET calls. I'm setting _url to the https URL, and _headers to a JSON object with an auth header. If I use the following syntax: let response := http("GET",…

Timestamp - 24 hours

I am trying to get a date time field to be set by button to 24 hours prior to current time.any help?

stumped

Failing to set up a simple calculation for a column. As an example:- if fasst.Id then let reg := "yes";else let reg := "no";endreg This fails with "End expected: reg at line 6,…

Is there a way to do versioning of fields?

I think about a database, that holds marketing data. I would like to edit w.g. a "slogan" once in a while, but keep history of versions. Do I need to have a separate table with entries for that?…

How to create a simple dynamic (parameter-dependent) image and convert it to * .png or * .jpg to an attachment

Hello, How to create a simple dynamic (parameter-dependent) image. Maybe html canvas maybe something else some idea? Please help :)

Does anyone know how to do auto logins for websites.

I need to create a button in ninox that will let me auto fill in login, password & push login button on websites.

[Linked Table] Search in Popup linked table entry not working

Hello everyone! I am having an issue whilst trying to search for records in a linked table. So, I have a Product Quote table where I insert several details regarding a certain Product Quote:…

Keep new data from being added to parent table

I have a parent table with the businesses clients listed in it. The client will assign a case to work on and in a child table, a user will select the client using the magnifying glass icon.…

Just for information (web version only)

Just for info re web version I placed and alert in combo box trigger after update and it sinply ignored it but rest of script worked well. support have come with :- "Thank you for your e-mail.…

Charts personalization

Good afternoon, I had two quick questions regarding charts: - Is it possible to order the bars in a bar chart from smallest to biggest amount/bar, or vice-versa?…

what format and size for an image field ?

self explanatory

Quick Formula question

When a Formula field is defined in a table (not just a calculated column in a list view) is the result saved to disc or is it only ever held in memory and simply calculated as required?…

Purging Job History

I want to delete all main JobDockets records and its child tables) if these exists before a given date (6 years approx) based on a date keyed into a delete for this date fieild (DeleteDate!…

disappearing formulas

I have just started testing the trial, which means web based and not the app. So far I have 2 tables, a parent and a child. Currently driving me nuts is that in the list view of the child table I add…

Update only some some children

Aplogise for the apparent favouritism, but I need to update the Date field of only those child records whose Date field is either in the future or simply blank/empty and not been able to figure out…

Return of the wife

Hey - I can get my wife back! - as long as I purchase a love spell !! These extras are being offered to us via the forum now so often tat I think Ninox should be including them with the next update :…

Upload file to image field via integromat

Just wondering if it would be possible to have a cognitoforms -> ninox integration via integromat, and have an image from the form upload to an image field in Ninox?…

the chosen one (or not)

I'm trying to access the choices from a Multi Choice (Dynamic) field, named 'colour' in the current table. Before I try more complicated concatenations (well, I tried but they failed),…