0

I am trying to display a value of "Yes" or "No" depending on if a checkbox is checked. If checked, I want to display "Yes" if not, display "No".

I have tried a few variants of the following code, but have not been able to get it to work. set

%%[var @rs2 Set @rs2= RetrieveSalesforceObjects('Reservation__c', 'SPF14_Purchased__c','Household__c','=', @ID)

set @row=row(@rs2,1) set @SPF14=field(@row,'SPF14_Purchased__c')

%%[IF (@SPF14 == True) THEN ]%% %%[ SET @SPF14 = Yes' ]%%

%%[ELSEIF (@SPF14 == False) THEN]%% %%[SET @SPF14 = 'No']%% %%[ELSE]%% %%[ENDIF]%% ENDIF ]%%

Improve this question
3
  • Try true and false instead of "true” and "false”. It’s hard to troubleshoot the rest of your script, as it seems incomplete Commented Jun 19, 2020 at 22:53
  • I tried true and false and that did not work. I added the rest of the script in my original question. Thank you for your quick response. Commented Jun 19, 2020 at 23:02
  • You have a variable @ID which is not set. And you could put all that script in one block, but that’s not the issue here Commented Jun 19, 2020 at 23:13

1 Answer 1

Reset to default
0

You have 2 endif however only one if is set. You should delete the additional endif in the end. Also your code is all ampscript and therefore 1 ampscript block should be used. Also ' was missing before the yes value. As zuzannamj metioned the @ID parameter is not defined. You should set it before using it to reterive the object from SF.

See fixed code below:

%%[ set @ID='Value should be inserted here' set @rs2= RetrieveSalesforceObjects('Reservation__c', 'SPF14_Purchased__c','Household__c','=', @ID) set @row=row(@rs2,1) set @SPF14=field(@row,'SPF14_Purchased__c') IF (@SPF14 == 'True' ) THEN SET @SPF14 = 'Yes' ELSEIF (@SPF14 == 'False' ) THEN SET @SPF14 = 'No' ENDIF ]%%
Improve this answer
1
  • Thank you Barak. Your recommendations were great. I did have to use double quotes ("yes" and "No") to get them to display. Thank you! Commented Jun 22, 2020 at 22:42

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.