TOPIC:

Get other form values fro database 1 month 4 days ago #241794

  • Topic Author
  • mrperfectpz
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 141
  • Thanks: 0
Hi

I have 2 forms and using 1 for the contentbuilder view. How would I use the content prepare to get values from the other form to use in this view ?

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

Get other form values fro database 1 month 4 days ago #241812

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9076
  • Karma: 167
  • Thanks: 737
Hi,

you could directly add a database query and pull the values from the other table.
But I assume you need to some sort of identifier to combine 2 or more rows (e.g. one or more columns).

Can you please tell me the exact table names you need this for (plus the ID columns)? Then I can add an example here.

Regards,
Markus

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

Get other form values fro database 1 month 4 days ago #241905

  • Topic Author
  • mrperfectpz
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 141
  • Thanks: 0
Hi Markus

I have very little knowledge of using database so can you point me in the direction please. I have no idea where to start sorry, all I know is the table prefix is bak_ffg13_

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

Last edit: Post by mrperfectpz.

Get other form values fro database 1 month 3 days ago #241912

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9076
  • Karma: 167
  • Thanks: 737
Ok, can you please tell me the following then:

- Are both forms CB native or combined with BreezingForms?
- If they are native (not using BreezingForms):
I need the names (not titles) of both data storages
- If there using BreezingForms I need the names (not titles) of the forms
- Then I need the field names (not titles) of the form that you want to pull data from to display in your content prepare template.

Once I got this data I can write you a matching example that should be working by copy and paste.

Regards,
Markus

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

Get other form values fro database 1 month 3 days ago #241950

  • Topic Author
  • mrperfectpz
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 141
  • Thanks: 0
Hi Markus

i am using breezingforms so details are:

Form name :

JOIN_LEAGUE

Field names :

JoinLeagueName
JoinLeagueID
JoinPlayerNames
JoinPlayerValue

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

Get other form values fro database 1 month 3 days ago #241974

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9076
  • Karma: 167
  • Thanks: 737
Ok, one more thing I need to know:

- Do you want to get all records from JOIN_LEAGUE or a particular one?

- If it should be a particular one, I need to know which field from JOIN_LEAGUE would connect with the current form in CB so I can connect 2 records into 1.

What both forms basically need is a value that they share (an ID) so I can determine if the 2 records belong to each other (otherwise you would get odd results).

Regards,
Markus

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

Moderators: ForumSupport
Time to create page: 0.051 seconds

July Sale!

Discounts for all of our extensions + support. Ending July 31st!

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!