| Login

SQLNotes' main web site has been moved. Click here to go to the new home page. From there you can download the Portable SQLNotes Zip file or view the dowload page.

 

Note: This Forum is now closed. Please use the new community web site.

Note that browsing / searching is still be possible

 
  Forums  SQLNotes Beta01  Suggestions  Always visible box for auto assigning field values
Previous Previous
 
Next Next
New Post 11/13/2008 10:37 PM
User is offline markfoley
15 posts


Always visible box for auto assigning field values 

In options currently there's an option by grid to 'auto assign the following fields' and you can put a comma separated list to assign those.  Can't seem to get that to work at the moment, eg I put in the 'welcome' table the following:

 

A:Who = "blah"

 

And some variations too.  When I show the 'Who' field, it is still blank when I create a new record.  Have I missed the point?

 

This is powerful and the use I see for it is for example having a field called 'where captured' and you could put 'meeting at such and such a time/place' which would appear on every row you capture in the meeting.  However I think the assignment box should be able to be put in the toolbar or a dockable panel so you can edit which fields are 'auto assigning' as you work.  Thoughts?

 
New Post 11/13/2008 10:52 PM
User is offline PPL
2056 posts


Re: Always visible box for auto assigning field values 

It doesn't currently work for text assignments. You can use Forms to add items with custom filled fields...


Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics).
 
New Post 11/14/2008 2:00 AM
User is offline Tom
443 posts


Re: Always visible box for auto assigning field values 
Modified By Tom  on 11/14/2008 3:00:47 AM)

 PPL wrote

You can use Forms to add items with custom filled fields...

 

and from the Wiki

> default values for each field can be defined for each form

 

I havent been able to figure this out - it doesnt seem to work automatically - do you simply mean that one can (manually) fill fields via the forms pane or

can you set it up so new item automatically has XYZ ticked and filled ?

 

thanks!

 
New Post 11/14/2008 9:58 AM
User is offline PPL
2056 posts


Re: Always visible box for auto assigning field values 

The way forms work is described in the wiki/forms:

In the Properties pane, you'll find all your forms.

  • Values can be entered in the grid or in any of the forms.
  • Notice the 3 icons when you open a form:
    • Clicking the first one will add a new item to the grid with the default values.
    • Clicking the second one will add a new sub-item to the grid with the default values.
    • Clicking the third one will apply the form to the current item


Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics).
 
New Post 11/14/2008 12:17 PM
User is offline Tom
443 posts


Re: Always visible box for auto assigning field values 
Modified By Tom  on 11/14/2008 1:26:08 PM)

Apologies Pierre and thanks

it's all there all right - I had skimmed through it - need to slow down a bit I do !!

 

EDIT/ new definition in Glossary

Does it sound okay?

 

  • Form - A form is is a grouping of Fields that shows in the Properties Pane. You can give these fields "default" values and then create a new item with these values or apply these values to selected item(s). See Forms
 
New Post 11/17/2008 3:58 PM
User is offline markfoley
15 posts


Re: Always visible box for auto assigning field values 

Thanks.  These forms are a bit strange I think, but I'll stick a new thread in the new forum!

 
Previous Previous
 
Next Next
  Forums  SQLNotes Beta01  Suggestions  Always visible box for auto assigning field values
Inspired by Nina