Custom fields and Formulas

[Alan Lord (News)]

Hi I have created a couple of custom fields in a module.

One is a picklist of integers (to use as a percentage) and the other is
a currency field.

I have an equation in the field formulas settings which correctly
calculates a figure and display it in my new custom currency field.

What I would like is to be able to make that currency field read-only by
the user so it can only be updated programatically by my equation.

Using the various configuration settings, I can only seem to either
enable the field (so it can be edited by the user), or it becomes
completely invisible and is not displayed at all.

Is this possible?

Thanks

Al

--
Alan Lord
The Open Learning Centre
Web: www.theopenlearningcentre.com



_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[Asha-3]

Hi Alan,

You can try setting the display type for the field to 2. In that case, the field will not be available for editing, but will be visible in the Detail view or List View. Check if that helps you.

On 10/2/09, Alan Lord (News) <alanslists@...> wrote:

Hi I have created a couple of custom fields in a module.

One is a picklist of integers (to use as a percentage) and the other is
a currency field.

I have an equation in the field formulas settings which correctly
calculates a figure and display it in my new custom currency field.

What I would like is to be able to make that currency field read-only by
the user so it can only be updated programatically by my equation.

Using the various configuration settings, I can only seem to either
enable the field (so it can be edited by the user), or it becomes
completely invisible and is not displayed at all.

Is this possible?

Thanks

Al

--
Alan Lord
The Open Learning Centre
Web: www.theopenlearningcentre.com



_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com

--
Regards,
Asha
vtiger Team
_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[Alan Lord (News)]

On 06/10/09 15:20, Asha wrote:
> Hi Alan,
>
> You can try setting the display type for the field to 2. In that case,
> the field will not be available for editing, but will be visible in the
> Detail view or List View. Check if that helps you.

Hi Asha, thanks for the suggestion that sounds about right.

Sorry for being thick but where should I be setting the display type to
2? I can't see that option anywhere?

Thanks again,

Alan



_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[David V.-2]

Alan,

You have to do it in the database directly.

Look for a table named vtiger_fields.

David V.

2009/10/6 Alan Lord (News) <alanslists@...>

On 06/10/09 15:20, Asha wrote:
> Hi Alan,
>
> You can try setting the display type for the field to 2. In that case,
> the field will not be available for editing, but will be visible in the
> Detail view or List View. Check if that helps you.

Hi Asha, thanks for the suggestion that sounds about right.

Sorry for being thick but where should I be setting the display type to
2? I can't see that option anywhere?

Thanks again,

Alan

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[Alan Lord (News)]

On 06/10/09 18:22, David V. wrote:
> Alan,
>
> You have to do it in the database directly.
>
> Look for a table named vtiger_fields.

Thanks David,

I wondered if that was the case.

Al

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 

[Alan Lord (News)]

On 06/10/09 18:22, David V. wrote:
> Alan,
>
> You have to do it in the database directly.
>
> Look for a table named vtiger_fields.

I finally got round to trying this out...

I changed the displaytype field to 2 but that seemed to stop the custom
formula from re-calculating at all. It never updated the value displayed
in the field.

I also noticed a field in the vtiger_field table called readonly! I
changed that from 0 to 1 but that didn't seem to make any difference at all.

Alan

>
>     On 06/10/09 15:20, Asha wrote:
>      > Hi Alan,
>      >
>      > You can try setting the display type for the field to 2. In that
>     case,
>      > the field will not be available for editing, but will be visible
>     in the
>      > Detail view or List View. Check if that helps you.

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com