Concatenate fields in list view

  • kenryanjr
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 134
  • Thank you received: 0

kenryanjr created the topic: Concatenate fields in list view

I have been using code like this in another site that works perfectly. The site I am using on is pulling the data from a data storage built in Content Builder. I use it to put three fields together in a list view.
<?php $col1036 = 'col1036' ; $value = $value . '&nbsp;' . $item->$col1036; ?><?php $col1041 = 'col1041' ; $value = $value . '&nbsp;' . $item->$col1041; ?>

I am trying on a new site that is using breezing forms data and content builder list view. It works, until you turn off "include in list". Then the two records you adding to the third don't work. Any idea what may be causing this?

In the attached images Chevrolet and 210 are being added to the year field. As you notice, the columns are there the chevrolet and 210 are there concatenated to 1954. Columns gone, chevrolet and 210 gone. But tested it with a content builder storage view and it works...Help!
#237723
Attachments:
  • Posts: 2553
  • Karma: 87
  • Thank you received: 343

mihaela replied the topic: Concatenate fields in list view

Hello,

I understand the issue you are having. You are right, concatenating fields values in the listed view using the following code:
<?php $col1036 = 'col1036' ; $value = $value . '&nbsp;' . $item->$col1036; ?><?php $col1041 = 'col1041' ; $value = $value . '&nbsp;' . $item->$col1041; ?>
in the Item Wrap Code will work for view based on Data Storage regardless of whether the fields are included in the view or no.

On the opposite, that will not be the case with a view created based on a BreezingForms form. If a view is created based on BreezingForms in order for the fields to be concatenated in the list view using that code they have to be included in the list.
That reason for this is in the way that fields get their ID's when creating a form or data storage.

I've been trying to find an alternative way to do what you want and came only to a conclusion that you could add an additional field in your form which would store the concatenated values and then you would include this field in the form.

It could be a "Turned off" textarea, so the form itself would not look different since this field would be hidden on editing.

Let me know whether that solution would work for you.

Regards,

Mihaela
#237729
  • kenryanjr
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 134
  • Thank you received: 0

kenryanjr replied the topic: Concatenate fields in list view

The best way to solve the problem is if someone wants to use Breezing forms...create the form, then create a data table in data storages based on the form and then use the integrator. That is what I did, and it works great and I still get the benefit of the Breezing Forms functionality and style. It is a little bit more time, but I go the desired result I wanted.
#237735
  • Posts: 2553
  • Karma: 87
  • Thank you received: 343

mihaela replied the topic: Concatenate fields in list view

Hello again,

I'm glad that you have found a way for this to work how you wanted.

Thank you for sharing with the community.

Regards,

Mihaela
#237740
Moderators: ForumSupporttomeperica
Time to create page: 0.076 seconds

New Icon Packs Category!

Crosstec is now offering icon packs.

If you are a paying subscriber, icon packs are automatically added to your account.

Check out our icon packs page!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Summer Sale!

50% discount on all of our extension subscription plans, templates and icon packs!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here