TOPIC:

Integrator - append string 2 weeks 4 days ago #257856

  • Topic Author
  • tomduda
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 5
  • Thanks: 0
hi,
is there a possibility how the integrator can append string sent over the form if there is already existing string in the column? E.g. there's already "abc" in the description column and I want append "xyz" that is submitted by the form's field. I understood that the Integrator is capable to sql-update the column, but that's effectively an overwrite operation.
Thank you.

Please Log in or Create an account to join the conversation.

Integrator - append string 2 weeks 4 days ago #257857

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 5361
  • Karma: 3
  • Thanks: 383
Hi,

The integrator is a nice way to store the data of your forms into any database table of your Joomla installation, so you can update existing entires too.
Here is documentation:
crosstec.org/en/support/online-documenta...-the-integrator.html

Hope this helps

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Integrator - append string 2 weeks 4 days ago #257859

  • Topic Author
  • tomduda
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 5
  • Thanks: 0
hi Tihana, thank you for the link, I've seen the tutorial, but maybe I'm missing some important bit, but the guidance shows how to update the column (in a row based on criteria) in the "overwrite" way.
I need to retain the string that is already in the database, but concatenate it with incoming string that user submits. So in fact I need to:
read the string from db > concatenate with incoming string > write resulting string back to the same row/column.

Please Log in or Create an account to join the conversation.

Integrator - append string 2 weeks 4 days ago #257862

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 5361
  • Karma: 3
  • Thanks: 383
Hi,

not sure this is possible, but I will test it, and try to find solution for this

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Integrator - append string 2 weeks 4 days ago #257864

  • Topic Author
  • tomduda
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 5
  • Thanks: 0
There's a workaround I've figured out: to read the string from database, put it into hidden textfield in the form and then send it back in another text field that would combine string from db and string entered by user. But that means sending the data back and forth, which seems unnecessary.

Please Log in or Create an account to join the conversation.

Integrator - append string 2 weeks 4 days ago #257867

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 5361
  • Karma: 3
  • Thanks: 383
Hi,

ah yes, sorry I went blind from looking at the display.

This is ok solution, but you are right this will send the data back and forth

Regards,
Tihana

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.046 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

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!