Skip to main content

Ninox-Documentation

Westy

Choices_Software_Dean

564
3
0

Joined: Sat Jun 15 16:44:57 UTC 2019

My Posts

Latest Posts

Re: How to lookup vehicle information based on vehicle ID number
How can I loop through and return the name and value of only those items that contain a value?
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Full Summary of Scripting Commands?
"command for returning a view name" I do not know of a function that returns the data entry form view. However, maybe a closer look at the form tabs would help.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Programming Language
There are numerous learning videos here (created by a CPA): https://www.youtube.com/c/NinoxLearning/videos
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Full Summary of Scripting Commands?
To hide a field, type null in the "Display field only, if" property of the field. You can hide or show fields based on other fields. For example, if you have a Choice field with values of "Hide" and…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Programming Language
Before you do too much work, are you aware that in the default table you can click the column header of any number column and select "Sum". You can also add or remove column(s).…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Programming Language
let t := (select Table1);if 'Certain Text' = "Field1" then alert(sum(t.Field1))else if 'Certain Text' = "Field2" then alert(sum(t.Field2)) endend
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How to lookup vehicle information based on vehicle ID number
It is now working. Anyone can try it. It uses one field named 'Veh ID No.' and the below button code. It only requires the first 10 characters of the 17 character vehicle ID number.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How to lookup vehicle information based on vehicle ID number
I've made progress. The below item() function returns "X3": let response := { SearchCriteria: "VIN(s): 5UXWX7C5*BA", Results: [{ Year: "2011", Make: "BMW", Model: "X3" }]};let v := item(response.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Programming Language
Ninox has its own language, which is similar to Javascript and sql. When assigning values be sure to use := instead of =. There is a "Reference of Scripting Functions" at: https://ninox.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How to lookup vehicle information based on vehicle ID number
Sean, thank you for your help. I seem to still be missing a piece of the puzzle. If the result returned is: { "SearchCriteria": "VIN(s): 5UXWX7C5*BA", "Results": [{ "Year": "2011", "Make": "BMW",,…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: i complitly don't understand how it work
Please ask a question. We are glad to help.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
How to lookup vehicle information based on vehicle ID number

The US Dept of Transportation provides examples of how to use their api, with multiple programming languages at: https://vpic.nhtsa.dot.gov/api/Home/Index/LanguageExampleshttps://vpic.nhtsa.dot.…
- Choices_Software_Dean
- 4 yrs ago
- 11replies
- 2124
- Get help
Re: I am new and as a result I a field Multiple Choice instead of a single choice, How do I change the field type?
Yes, if you delete a field you will loose that data. To my knowledge there is no way to just change a field type.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: I am new and as a result I a field Multiple Choice instead of a single choice, How do I change the field type?
Under the Actions pulldown menu, select "Edit field". Drag new field to center column. Delete old field. The fields will appear on the form layout in the same order as they are listed in the center…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Mehrere Datensätze in Untertabelle gleichzeitig hinzufügen in Tabelle
It may not be possible to determine which records are checked using a select statement. It seems that information is stored per session, not per database. I hope I am wrong.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Mehrere Datensätze in Untertabelle gleichzeitig hinzufügen in Tabelle
My first thought was to place a check beside desired Items by clicking the first column. However, I could not find a way to test for checked records. Maybe someone else can help.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Mehrere Datensätze in Untertabelle gleichzeitig hinzufügen in Tabelle
Question: How to select several Items and relate them in one step. Answer: 1. go to Items table 2. add "Relate" column (text) 3. enter "X" (or any text) in rows to relate 4.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
The below arrangement with three tables seems to work. The "Players" and "Lookups" tables have the same columns.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
With this approach, the solution could look like the screenshot below, with the Players reference field on the far right acting simlar to a Choice field,…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
Oh, you want to do a lookup that pulls data from the Players table to unrelated fields in the Roster table? Similar to selecting from a Choice field, except the choices are records from the Players…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Comment pouvoir récupérer les données d'un enregistrement antérieur dans un nouvel enregistrement ?
Question: I would like a table to appear with the repairs already carried out and that when I click on a row in this table, some data (fields) would be copied on the current record (this in order not…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Comment pouvoir récupérer les données d'un enregistrement antérieur dans un nouvel enregistrement ?
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Open a record with a button
No sure if I understand what you want. If you click the "bla" sub record above it will bring you to the Contact Edition form. If you place a button there with the code:…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula to populate a multi-line text field
To make it work for "Rich Text" use html in your button code, like this: let v := "<b>" + name + "</b><br>" + address1 + "<br>" + address2 + "<br>" + city + ", " + state + " " + zip;…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
Do you want something like this, or a different related table for each position, or something else?
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view

1 4 5 6 7 8 23

Back to top

Ninox-Documentation

Overview

View all topics