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: Database Find, what determines the columns shown when performing a search?
The sidebar find searches across all tables. I am not aware of any way to control the columns shown for that search. For the search at the top of any list,…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How can i create an autonum field in ninox ?
See: https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4?post=5d5eee964c38db4f7ed61368&page=1
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Database Find, what determines the columns shown when performing a search?
Yes, only the columns shown are searched. The default is the first seven columns. Add columns as needed. Click red tool button first. Then make changes and click the tool button again to save your…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Images vs Attachments
It is possible to save documents as links to reduce database size. Stephen has a post on this at: https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/displaying-external-dropbox-images.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic create table reference
I may not be following. Is the issue not being able to use a variable? If the template table has a Choice field with the country names. Then you can access the current country name from within…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic create table reference
Please provide your table and column names.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Script to export all databases
The Ninox Cloud includes automated backups. Click to the right of the database icon and select "Create backup" and then click the "Automated Backups" tab to see your backups.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Many-to-many referenced table magnifying glass, what is it supposed to do?
Search a list of related items, so you can select one. Are you sure it is a many-to-many reference? Usually they do not work. If that kind of reference is needed,…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How can I populate a Bill To address from Job address if both the same?
In code, field names that contain a space must be surrounded by single quotes. Double quotes are used for static text. For this reason you may want to stay away from using quotes within field names.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How can I populate a Bill To address from Job address if both the same?
In invoice table go to Edit Fields and from the right column drag the Customer table reference over to the center column. Change the name of your choice field to Choices.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula to populate a multi-line text field
Our a button formular to populate the multi-line field: let v := name + "" + address1 + "" + address2 + "" + city + ", " + state + " " + zip;'Text (multiline)' := v
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula to populate a multi-line text field
Place in a formular field: name + " " + address1 + " " + address2 + " " + city + ", " + state + " " + zip
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there any way to copy a value list (US States) from one table to another?
Why do you want to use a choice field for thousands of items? It seems like a view element to a related table would be better. Views support filtering and sorting.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there any way to copy a value list (US States) from one table to another?
Is the intended destination a choice field? If so, I do not think there is any way to import values into a choice field. If you just want to copy records from one table to another table,…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to order the "Many" list when making a selection?
Bring up the Object table's form. It should have a view showing the related Dates table. Click the red Tools button on the right. Click the Dates column header within the view and select Descending.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
Oops. I should have typed: "GP-00" + text('Customer ID Number')
- Choices_Software_Dean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Maximum size
You did not mention a "loop" in your first post. Please provide more detail about what you "loop" is doing and when it is "blocked". If you can provide sample code, that might help.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Inserting a line in a table
Please let us know the answer, following your call. I think it is an interesting question. My first thought is to have a auto-numbered sorted column that contains numbers like: 1.000 2.000 3.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How do I index an entry
Check-off the field's "Index" property.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
Try it with a formula field and a number field: Customer ID Formula Customer ID Number Trigger on Create: 'Customer ID Number' := max((select Table1).'Customer ID Number') + 1 Formula in 'Customer ID…
- Choices_Software_Dean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Limited to One form per table?
Also, note that in print preview mode you can create multiple form layout for printing, by adding tabs.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Limited to One form per table?
You can use a choice field instead of tabs. This will allow you to control the visibility of each element on the form based on the item selected from the choice field,…
- Choices_Software_Dean
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Chart monthly
See Data Visualization video at: https://www.youtube.com/watch?v=IObCC1cbHbA
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Condition where
Would filtering using "where" help? Below is an example from documentation: sum((Invoice where Status = 2).Amount)sum(Invoice[Status = 2].Amount)
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there an easier way to convert a payment choice into a number?
let n := number(text('Chose Payment Amount'));n
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view

1 9 10 11 12 13 23

Back to top

Ninox-Documentation

Overview

View all topics