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: Can a html form within a formula field pass its data to Ninox?
Wow! That is a really creative solution. I am going to experiment with that. There is an interesting tutorial on data binding at: http://learn.knockoutjs.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Application "Home Page"
Good idea! We have something similar. We have a "Preferences" table with one record and one form. The Preferences table opens to a form, not a table. There is a Choice field named "Startup Table" on…
- Choices_Software_Dean
- 4 yrs ago
- Learn and share
- Reported - view
Re: What is the current scope for formulas in View fields
let v := this.Last;select Person where Last < v
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way of setting ID counter back to 1
"the ID column is part of the 'GANTT' view" Could you please show a screen shot?
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way of setting ID counter back to 1
I am guessing that you might be confusing the row number column with the Id column. Unlike the row number column, the Id column contains a unique Id for each row.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
What you see is what you get forms (WYSIWYG)

Our users want the option to fill-in WYSIWYG forms; in addition to responsive forms. Ninox is almost there. The Ninox print preview layout already supports the precise positioning of form elements on…
- Choices_Software_Dean
- 4 yrs ago
- 422
- Learn and share
Re: Is it possible to use the BUTTON to open other applications (ie: different web pages). In advance, thanks for your assistance.
si la page Web le permet, vous pouvez passer le nom d'utilisateur et le mot de passe dans l'URL, mais ce ne serait pas très sécurisé.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
Yes, the t could be any letter or name. Think of it as a container of rows (ids) and columns (name/value pairs).
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Can a html form within a formula field pass its data to Ninox?

I see that a formula field can properly render a complete html form. Can data entered into such a form be passed to Ninox, either by using a form action submit,…
- Choices_Software_Dean
- 4 yrs ago
- 7replies
- 1291
- Get help
Re: Is it possible to use the BUTTON to open other applications (ie: different web pages). In advance, thanks for your assistance.
Yes. openURL("https://google.com")
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: copying value at bottom of table
You could create a new table with one record. Replace the default table view with a blank form view. Then add a button, plus a text field named "Filter" and a text (multiline) field named "Emails".…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
Yes, you can create a new "Dashboard" table, that I mentioned earlier, with one record. Replace the default table view with a Form view (click the "+" to create the Form view),…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: copying value at bottom of table
A possible workaround is to place code in a formula field. A where condition could be added to this select statement. Or you could export. let t := (select Table1);let e := concat(t.email);e
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Updating tables
Looks like one has a "Design" column filter and the other does not.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Updating tables
I think I understand your question now, but unfortunately I do not have an answer. Maybe someone else can help.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Static AND Dynamic Google Map with Multiple Markers
Very nice! Thank you Steven.
- Choices_Software_Dean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Creating a Trial Balance
If 'ACCOUNTS DETAILS' is your field name and "SUBS" is text typed into that field, then it should work. Notice that field names containing spaces must have single quotes and static text must have…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Updating tables
Please provide screenshot.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
Revisiting your examples above, if "SUBS" is just discriptive text, then maybe something like this would work: let t := (select Ledger where 'ACCOUNT DETAILS' = "SUBS");let c := sum(t.credits);
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
You can learn from the video without subscribing. Later, you can subscribe if you want to support them. The videos represent a lot of work, and now it appears they have to do some of their videos…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
See this video "Dashboards & Views With Hidden Tables": https://www.youtube.com/watch?v=nUqGl84gh08
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a Trial Balance
I know nothing about accounting, but you can sum columns like this: let t := (select Ledger);let d := sum(t.debits);let c := sum(t.credits);d - c I do not understand what filter you want to apply.…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Same field to appear multiple times with same name
You could create your own "tabs" using a Choice field, per below. That gives you complete control over what fields are visible. However, be aware that the last item selected will always be remembered…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: Hi All
Paste what Steve has provided into a formula field, and substitute your table name and your yes/no field name. For example, with default names, it would look like:…
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view
Re: How to lookup vehicle information based on vehicle ID number
Okay. Thank you Sean.
- Choices_Software_Dean
- 4 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 23

Back to top

Ninox-Documentation

Overview

View all topics