Westy

Choices_Software_Dean

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

My Posts

Latest Posts

Re: Maximum size
How many tables are in the database and how many columns per table? What are the column data types: numbers, text, images, etc. I assume the 25,000 "items" are records.…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Working with formulas
let v := 'field a' > 0 and 'field a' < 27;if v then let a := 'field a'; let p := (create 'TABLE 1'); p.('field b' := a)end
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: View form only
Another possibility is that when you "created" the form you did so by clicking the "+" beside the default "(all)" tab. If that is what you did, then click the tab(s) to the right of the "(all)" tab.
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: View form only
The Form and Table buttons above should allow you to toggle between the two views. The Table button also allows you to enter or edit data directly on the table.
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Locking records
Did you set "Writable if" property to null?
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Export Record, Import Record?
let s := "";switch text(Choice) do case "Televisions": (s := "Televisions") case "Radios": (s := "Radios") case "": (s := "")end;let t := (select ParentTableName where text(Choice) = s);let n := 0;…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Export Record, Import Record?
let t := (select ParentTableName where text(Choice) = "Televisions");let n := 0;for i in t do n := n + 1; let p := (create ChildTableName); p.('Carrier Number' := i.'Carrier Number'); p.…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: linking tables only using a numeric field
In my quick test, I was able to see what you describe. Unfortunately, I do not know how to resolve the situation. Maybe someone else can help.
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Export Record, Import Record?
What criteria do you want to use to select the records that will be copied to Table2?
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Export Record, Import Record?
Put a button on the Table1 form, with the following on click code. let t := (select Table1);let n := 0;for i in t do n := n + 1; let p := (create Table2); p.('Field 1' := i.'Field 1'); p.…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: linking tables only using a numeric field
I see what you mean. When yu test, does it happen when the related number field is not named "Number"?
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Mass Create Records in a Sub-Table.
Use below code instead of the above code: let t := (select ParentTableName);let n := 0;for i in t don := n + 1;let p := (create ChildTableName);p.('Carrier Number' := i.'Carrier Number');p.…
- Choices_Software_Dean
- 5 yrs ago
- Learn and share
- Reported - view
Re: How to Mass Create Records in a Sub-Table.
Place above code in button on parent table form.
- Choices_Software_Dean
- 5 yrs ago
- Learn and share
- Reported - view
Re: How to Mass Create Records in a Sub-Table.
let t := (select ParentTableName);let n := 0;let c := null;let s := null;for i in t don := n + 1;c := i.Field1;s := i.Field2;let p := (create ChildTableName);p.(Field1 := c);p.(Field2 := s)end
- Choices_Software_Dean
- 5 yrs ago
- Learn and share
- Reported - view
Re: Creando un registro en una tabla que tiene enlaces con otras tablas
let v1 := Customers;let v2 := Sellers;let p := create Planning;p.Customers := v1;p.Sellers := v2
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Space colour
In the future you might run into a similar issue using the Free Text element. That element allows you to set both its Text Color and Background color properties: Style Text/Background color/RGB:R 238,…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Link to view
Add a new view element to form A, with a formular property: select 'Table C'
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Help! I just erased an important contact
I assume when you say "erased" you mean permanently deleted, not temporarily omitted or filtered. If deleted it is best to restore from a backup asap (before entering more data).…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Besoin aide ouvrir et imputer
Peut faire avec l'intégration d'Integromat avec Ninox: https://youtu.be/UmUeXKvJLpI
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: How to print (or copy) a unique record instead of printing the entire database in tabular form
While viewing form detail, click print icon at upper right to enter print preview mode. Then click print icon again at upper right, and select "This record" from pop-up.
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Une image statique pour tous les records d'une table
See prior post at: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/static-image-5bc220e925979e54233efc49
- Choices_Software_Dean
- 5 yrs ago
- Learn and share
- Reported - view
Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?
For example, create a Invoice table with columns named Description and Amount. Populate the table with a few records containing corresponding text and numbers.…
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Can you copy/duplicate a field?
Are you asking how to setup a data table that just has two columns (ie. fieldname and fieldvalue), and then use that data table to populate the form fields of a parent table?
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?
See "Using the Select statement": https://www.youtube.com/watch?v=0AzrJvz8efQ
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view
Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?
Select statement is not needed. Click on Number column header and select Ascending or Descending.
- Choices_Software_Dean
- 5 yrs ago
- Get help
- Reported - view

1 10 11 12 13 14 23

Welcome to the Ninox community

Westy

My Posts

Re: Maximum size

Re: Working with formulas

Re: View form only

Re: View form only

Re: Locking records

Re: Export Record, Import Record?

Re: Export Record, Import Record?

Re: linking tables only using a numeric field

Re: Export Record, Import Record?

Re: Export Record, Import Record?

Re: linking tables only using a numeric field

Re: How to Mass Create Records in a Sub-Table.

Re: How to Mass Create Records in a Sub-Table.

Re: How to Mass Create Records in a Sub-Table.

Re: Creando un registro en una tabla que tiene enlaces con otras tablas

Re: Space colour

Re: Link to view

Re: Help! I just erased an important contact

Re: Besoin aide ouvrir et imputer

Re: How to print (or copy) a unique record instead of printing the entire database in tabular form

Re: Une image statique pour tous les records d'une table

Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?

Re: Can you copy/duplicate a field?

Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?

Re: Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?

Overview