You’re offline. This is a read only version of the page.
Announcements
8
Hey there, first time caller 👋 I'm having issues with a Combo Box.
I'm pulling in a list data from an Excel table connector: ["Name","Campaign"]. No issues there.
Searchable is set to "true".
I'm trying to allow someone to either select from the existing items in the combo box (e.g., fish-fy24) or they can enter their own option (e.g., catsanddogs). Whatever they do, I need to append some text (&utm_campaign=) and then pass the entire value to a separate field. If they haven't selected anything, or typed in anything, then there should be nothing in the separate field. For my separated field, I'm using Concatenate to pull together data from other fields (including the combo box data) and then displaying that.
I'm running into issues getting that data to pass to the field, but I'm also having issues NOT showing the appended text when nothing is typed-in/selected. Any help would be appreciated. See below (code and image):
Code:
Share
ReportConcatenate(
If(WebsiteURL.Text <> "", WebsiteURL.Text),
If(UTMSource.Text <> "", "?utm_source="&UTMSource.Text),
If(UTMMedium.Text <> "", "&utm_medium="&UTMMedium.Text),
If (
Or('cb-UTMCampaign'.Selected.Campaign <> "", 'cb-UTMCampaign'.SearchText <> ""),
Coalesce("&utm_campaign=", 'cb-UTMCampaign'.Selected.Campaign, 'cb-UTMCampaign'.SearchText),
""
),
If(UTMContent.Text <> "", "&utm_content="&UTMContent.Text),
If(UTMTerm.Text <> "", "&utm_term="&UTMTerm.Text)
)
Image
Figured it out...changed the two lines to just !IsBlank
That seems to have done the trick.
All responses (
Answers (
Concatenate(
If(WebsiteURL.Text <> "", WebsiteURL.Text),
If(UTMSource.Text <> "", "?utm_source="&UTMSource.Text),
If(UTMMedium.Text <> "", "&utm_medium="&UTMMedium.Text),
If(!IsBlank('cb-UTMCampaign'.SearchText), "&utm_campaign="&'cb-UTMCampaign'.SearchText),
If(!IsBlank('cb-UTMCampaign'.Selected.Campaign), "&utm_campaign="&'cb-UTMCampaign'.Selected.Campaign),
If(UTMContent.Text <> "", "&utm_content="&UTMContent.Text),
If(UTMTerm.Text <> "", "&utm_term="&UTMTerm.Text)
)
