Currently using the AMPscript below to set some variables for some IF
and ELSEIF
function for dynamic content. We need to pull these data fields into the data extension used to send the campaigns each time. Is there a way to set these variables from records in another data extension or contact data?
Editing to show what the full script is doing:
%%[ Var @Level1RewardsAvailable__c Set @LV1 = [Level1RewardsAvailable__c] ]%%
%%[ Var @Level2RewardsAvailable__c Set @LV2 = [Level2RewardsAvailable__c] ]%%
%%[ Var @Level3RewardsAvailable__c Set @LV3 = [Level3RewardsAvailable__c] ]%%
Then
%%[ Var @Level1RewardsAvailable__c Set @LV1 = [Level1RewardsAvailable__c] ]%%
%%[ Var @KLevel2RewardsAvailable__c Set @LV2 = [Level2RewardsAvailable__c] ]%%
%%[ Var @Level3RewardsAvailable__c Set @LV3 = [Level3RewardsAvailable__c] ]%%
%%[IF @LV1 == "0" AND @LV2 == "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\1_Rewards_LHS_Getscanning")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 == "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\2_Rewards_LHS_freeside")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 != "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\3_Rewards_LHS_freesnack")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 != "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\3_Rewards_LHS_freesnack")=%%
%%[IF @LV1 != "0" AND @LV2 != "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 != "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 == "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 == "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%%%[ENDIF]%%
%%[ Var @KFCP_Level1RewardsAvailable__c Set @LV1 = [KFCP_Level1RewardsAvailable__c] ]%%
%%[ Var @KFCP_Level2RewardsAvailable__c Set @LV2 = [KFCP_Level2RewardsAvailable__c] ]%%
%%[ Var @KFCP_Level3RewardsAvailable__c Set @LV3 = [KFCP_Level3RewardsAvailable__c] ]%%
%%[IF @LV1 != "0" AND @LV2 != "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 != "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 == "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 == "0" AND @LV3 != "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\4_Rewards_LHS_5off")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 != "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\3_Rewards_LHS_freesnack")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 != "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\3_Rewards_LHS_freesnack")=%%
%%[ELSEIF @LV1 != "0" AND @LV2 == "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\2_Rewards_LHS_freeside")=%%
%%[ELSEIF @LV1 == "0" AND @LV2 == "0" AND @LV3 == "0" THEN]%% %%=ContentBlockByName("Content Builder\Iris Campaigns\Dynamic Content Modules\Rewards Modules\1_Rewards_LHS_Getscanning")=%% %%[ENDIF]%%