Submitted by David_H on 2015/02/08 18:02
Is there any way to have several fields filled out automatically upon the creation of a new item - across MULTIPLE grids?  Some of the fields are yes/no, some auto-lists, and I would like to have about five of the fields default to certain values when an item is created.
 
Thanks

Comments

David,
 
Data entry (and defaults) are available by means of forms www.sqlnotes.net/drupal5/index.php. If by "automatic" you mean with some fields dependent on the values of others (not necessarily displayed in the form), then you will need to consider the use of equations, most probably in this case row equations. See: www.sqlnotes.net/drupal5/index.php.
 
Mark GREGORY, Redon, France - GMT +1/+2; EST +6

Hi David,
 
There are actually quite a few ways to do this. Just to name a few:
  1. Using forms: 1-Create an item by form, 2-Create sub-item by form, 3-Apply form to an item
  2. Using grid properties > Data
  3. Using field properties > Equations > Auto-Assign rules (if you set auto-assigns to the field which is the grid source, any TLI item you add will trigger its auto-assign rules)
HTH !
 
Pierre_Admin

Armando

2015/02/10 01:50

Permalink

Just to add to what others said : make sure you look at this Field Management Dialog - Equations in the manual/help file.
 
E.g.: your task field could have these auto-assign equations:
 
A: inbox = 
A: now = -1
 
E: inbox=-1
 
...means that when task is checked, the inbox field is emptied (or set to 0 in that case), and the now field will be checked.
When the task is unchecked, inbox is checked.
 
You can do much more complex things by using VB functions, etc. You can also use strings, dates, etc.
 
Just be careful no to erase data by mistake when playing with equations. also keep in mind that more equations = impact on performance.
 
 
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz


That's the sort of thing I only do very occasionally - and usually get help here ;-)
although, once you get one or two setup, it's often easy enough to simply copy them and modify as appropriate
 

Thanks everyone, I'll check those options out.