Looking for help with Calculated Field on Request Custom Form | Community
Skip to main content
JamesM-MERGE
JamesM-MERGE
Level 4
May 17, 2023
Solved

Looking for help with Calculated Field on Request Custom Form

  • May 17, 2023
  • 1 reply
  • 1195 views

I have a Request Custom Form that allows the user to identify if the Request is for a single asset or multiple assets. Some Asset Categories have an associated child Asset Type, other Asset Categories do not.

 

I want the Asset Type field to pull in the specific child asset type selection (i.e. Print Asset Type=Letter), or the Asset Category selection that does not have any child asset type, or both. Currently, the field is functioning as expected but it's confusing.

I believe I need an IF statement, but I'm not sure how to write this. I would appreciate any help in making this work.

Asset Type Calc: CONCAT({DE:Print Asset Type},{DE:Web Asset Type})

Asset Type: CONCAT({DE:Asset Type Calc},{DE:Asset Cat Single Calc},{DE:Asset Cat Multi Calc})


I have the following sample fields and Request report:

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JamesM-MERGE

I believe I've solved this.

CONCAT(IF(CONTAINS("Print",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Print",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("Letter",{DE:Asset Type Calc}),"Letter, ",""),
IF(CONTAINS("Print",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Print",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("Statement Stuffer",{DE:Asset Type Calc}),"Statement Stuffer, ",""),
IF(CONTAINS("Web",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Web",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("Marketing Page",{DE:Asset Type Calc}),"Marketing Page, ",""),
IF(CONTAINS("Web",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Web",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("Website Update",{DE:Asset Type Calc}),"Website Update, ",""),
IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("Employee Award Submission",{DE:Asset Type Calc}),"Employee Award Submission, ",""),
IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Multi-Select}),"",""),
IF(CONTAINS("Awards & Recognition",{DE:Asset Category - Single Select}),"",""),
IF(CONTAINS("JD Power",{DE:Asset Type Calc}),"JD Power, ",""),
IF(CONTAINS("Logo",{DE:Asset Category - Multi-Select}),"Logo, ",""),
IF(CONTAINS("Logo",{DE:Asset Category - Single Select}),"Logo, ",""),
IF(CONTAINS("Corporate Giving Request",{DE:Asset Category - Multi-Select}),"Corporate Giving Request, ",""),
IF(CONTAINS("Corporate Giving Request",{DE:Asset Category - Single Select}),"Corporate Giving Request, ",""),
IF(CONTAINS("Event Material",{DE:Asset Category - Multi-Select}),"Event Material, ",""),
IF(CONTAINS("Event Material",{DE:Asset Category - Single Select}),"Event Material, ",""))

 

1 reply

JamesM-MERGE
JamesM-MERGEAuthor
Level 4
May 18, 2023

I've made some progress, but still not there yet. Any help is appreciated!

 

CONCAT(IF({DE:Asset Category - Single Select}="Print"&&{DE:Print Asset Type}="Appetite Guide","Appetite Guide",
IF({DE:Asset Category - Single Select}="Print"&&{DE:Print Asset Type}="Letter","Letter",
IF({DE:Asset Category - Single Select}="Print"&&{DE:Print Asset Type}="Statement Stuffer","Statement Stuffer",
IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Help Text/FAQs","Help Text/FAQs",
IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Marketing Page","Marketing Page",
IF({DE:Asset Category - Single Select}="Web"&&{DE:Web Asset Type}="Web Banner","Web Banner",
IF({DE:Asset Category - Single Select}="Logo","Logo"
))))))))
MattHynes
MattHynes
Level 2
May 19, 2023

I've got to admit this is blowing my mind a bit.  To clarify, are there two fields someone could use to request assets?  If they need one type, they use Single-Select & if they need multiple, the use Multi-Select?  Assuming yes, if Web or Print are chosen, then the requestor would see the Print asset or Web Asset type?  Are the Web Asset & Print Asset type single selects?

JamesM-MERGE
JamesM-MERGEAuthor
Level 4
May 19, 2023

Yes, Web Asset Type and Print Asset Type fields are single select.

This is my latest attempt to simplify:

CONCAT(
IF(CONTAINS("Print",{DE:Project Category - Multi-Select})&&
IF(CONTAINS("Letter",{DE:Print Project Type},"Letter, ",""),
IF(CONTAINS("Print",{DE:Project Category - Multi-Select})&&
IF(CONTAINS("Statement Stuffer",{DE:Print Project Type},"Statement Stuffer, ","")
)))))
Terms & ConditionsAccessibility statement

Loading footer...