Hello, I want to create some defaults in functionality for some fields and to be able to change them after. Is it possible or do I need to use something else?
Solved
Autogenerated fields
+1- Vanguard
- 24 replies
Best answer by Mark Jongeling
ElenaTodirenchi wrote:
So I have a default that is completing some fields. I want to be able to modify the values completed by the default. I am not able to do that now as they are automatically overwritten by the default's values.
You can add a IF statement (or where clause) to the set/select query that prevents the overwrite of the column value. For example:
if @customer_first_name is not null
and @customer_last_name is not null
and @customer_name is null -- Not set yet
begin
set @customer_name = @customer_first_name + ' ' + @customer_last_name
endDoes that help out?
This topic has been closed for replies.
+23Hi,
To me it is a bit unclear of what you would like to create. Could you explain it a bit more, maybe even add some images?
If you mean to changing the value of one field should trigger another field's value to change too, then yes the Default logic can help as it is called upon adding/editing and after each time a field changes value. More info here: https://docs.thinkwisesoftware.com/docs/sf/business_logic
+1- Vanguard
- 24 replies
So I have a default that is completing some fields. I want to be able to modify the values completed by the default. I am not able to do that now as they are automatically overwritten by the default's values.
+23ElenaTodirenchi wrote:
So I have a default that is completing some fields. I want to be able to modify the values completed by the default. I am not able to do that now as they are automatically overwritten by the default's values.
You can add a IF statement (or where clause) to the set/select query that prevents the overwrite of the column value. For example:
if @customer_first_name is not null
and @customer_last_name is not null
and @customer_name is null -- Not set yet
begin
set @customer_name = @customer_first_name + ' ' + @customer_last_name
endDoes that help out?
"Wake me up before you low-code" | On holiday 06-02 till 27-06
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.