Submitted by David_H on 2015/03/25 16:48
Suggestion 1: Right now to apply a forum you have to select a form in the properties pane and click on one of the itsy bitsy icons.  I could be wrong but I'm betting for a specific grid most users are applying the same form.  So a nice enhancement would be if a default form could be assigned to a grid, the purpose of which would be that you could also provide shortcuts to activate the default form.  For instance I might enter an item, then right click and select "apply default grid form".  Alternatively there could be a toolbar icon for "apply default form grid".
 
Suggestion 2:  I'm setting up about 10 forms and they are all identical except for one field.  Tools>Manage Forms, it would nice to be able to right click on a form and copy it.
 
Thanks

Comments

Good idea...
 
One question, why setup 10 different, but so similar, forms ?
You know that it is possible to have a form ask you for a value ? i.e. show a dialog to enter a specific value...
 

David_H

2015/03/25 18:37

Permalink

[quote=Pierre_Admin]
Good idea...
 
One question, why setup 10 different, but so similar, forms ?
You know that it is possible to have a form ask you for a value ? i.e. show a dialog to enter a specific value...
 
[/quote]
Because I haven't gotten that far yet .  I figured I'd start with what is easy so I can be using them immediately.

Pierre_Admin

2015/03/25 19:17

Permalink

To have a form ask you to enter a value, simply enter =inputbox("caption", "dialog title") in the desired cell
 
HTH
 
Pierre_Admin
 

Armando

2015/03/25 19:56

Permalink

[quote=Pierre_Admin]
To have a form ask you to enter a value, simply enter =inputbox("caption", "dialog title") in the desired cell
 
HTH
 
Pierre_Admin
 
[/quote]
 
Didn't know that...! I use inputbox extensively in  fields equations, but didn,t know you could use them in the form configuration dialog. Is that documented ?
 
(That said, using many similar forms can have advantages when the content varies slightly, but in important ways... and one doesn't want to remember and retype that every single time)
 
Shortcuts : for a long time, I thought that even fields (Boolean especially) should be able to be assigned keyboard shortcuts.
 
 
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Pierre_Admin

2015/03/26 00:36

Permalink

[quote=Armando]
Didn't know that...! I use inputbox extensively in  fields equations, but didn,t know you could use them in the form configuration dialog. Is that documented ?
[/quote]
Somewhat, in 4. Forms
 

Tom

2015/03/26 09:25

Permalink

 I updated that section a little - please (someone) check as it's not something I use much
Set Field default values
  • The default values will be set for the specified fields when one of the 3 icons on the form in the properties pane is clicked.
  • Use the second column to enter default values
  • You can enter equations as the default value e.g. to have a form ask you to enter a value, simply enter =inputbox("caption", "dialog title")
  • For text field, simply enter the text string.
  • For dates, =Now gives the current date and time, while =int(now) gives the current date
  • For yes/no, =-1 is checked, leave blank for unchecked
  • In the above example, StartDate will be give it's field default value ("_auto" is a special code to say apply field default value), Duration is 1 and Billing will be checked (=-1 is checked)
  1. added highlighted text
  2. made cell content bold
  3. removed '=' sign when it wasnt in cell content. I found it slightly confusing to say e.g. '=-1 = checked'
  4. [edit] updated the equations link (it was going to a dead wiki page [/edit]
 The field where you comment in the changes to the page seems to be gone (or I missed it) - no biggee, just saying :-)

Armando

2015/03/26 12:36

Permalink

> I updated that section a little - please (someone) check as it's not something I use much
 
Thanks Tom. Seems good to me.
 
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Pierre_Admin

2015/03/26 00:38

Permalink

[quote=Armando]
Shortcuts : for a long time, I thought that even fields (Boolean especially) should be able to be assigned keyboard shortcuts.
[/quote]
Should be easy to do...
 

Armando

2015/03/26 12:35

Permalink

[quote=Pierre_Admin]
[quote=Armando]
Shortcuts : for a long time, I thought that even fields (Boolean especially) should be able to be assigned keyboard shortcuts.
[/quote]
Should be easy to do...
[/quote]
 
Great!
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz