Re: Fill wirh a script

[Murray Cumming <murrayc murrayc com>]

On Tue, 2007-10-16 at 12:36 +0200, Federico Munerotto wrote:
> On mar, 2007-10-16 at 08:46 +0200, Murray Cumming wrote:
> > On Sat, 2007-10-13 at 19:59 +0200, Federico Munerotto wrote:
> > > How can I say a field to be filled with
> > > return record.related["marche"]["nome"] ?
> > >
> > > As developer, in layout, I've been able just to add a button and not
> > > such field.
> >
> > You can define a calculation for a field and then add that field to the
> > layout.
>
> You meant:
> SELECT *, description as description2 FROM mytable where MYCOND
>
> and add in layout .description2 ?

No, you don't need to write any SQL.

Just create a new field.
Then edit that field.
Then go to the Value tab.
Then specify a calculation, such as "record.related["marche"]["nome"]"
Close the Field Definitions window and put the new field on the layout.

The "small business" example does this for the name_full field.

-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com