How could I combine these three if statements? I’ve tried variations of OR and AND and more or less don’t know what I am doing. Thank You!
=IF("{{167671070__Marketplace Access}}"="Full Access","marketplace_full"),
=IF("{{167671070__Marketplace Access}}"="Pending Request","marketplace_pending"),
=IF("{{167671070__Marketplace Access}}"="Partial Access","marketplace_partial"),
Best answer by Troy Tessalone
Hi
Good question.
A Code step would be better suited for this logic.
INPUT
CODE
JavaScript
let MarketplaceAccess = inputData.MarketplaceAccess;
if (MarketplaceAccess == "Full Access") {
MarketplaceAccess = "marketplace_full";
}
if (MarketplaceAccess == "Pending Request") {
MarketplaceAccess = "marketplace_pending";
}
if (MarketplaceAccess == "Partial Access") {
MarketplaceAccess = "marketplace_partial";
}
output = [{MarketplaceAccess}];
OUTPUT
+14Hi
Good question.
A Code step would be better suited for this logic.
INPUT
CODE
JavaScript
let MarketplaceAccess = inputData.MarketplaceAccess;
if (MarketplaceAccess == "Full Access") {
MarketplaceAccess = "marketplace_full";
}
if (MarketplaceAccess == "Pending Request") {
MarketplaceAccess = "marketplace_pending";
}
if (MarketplaceAccess == "Partial Access") {
MarketplaceAccess = "marketplace_partial";
}
output = [{MarketplaceAccess}];
OUTPUT
+14Actually you can use a Formatter > Utilities > Lookup Table Zap action step for this: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.