TOPIC:

Pre-fill values when creating new record 4 years 7 months ago #178883

  • Topic Author
  • mvanderkruk
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 14
  • Thanks: 0
Is it possible to pre-fill some of the fields in the edittable-view with the last value entered into the field by the same user?
I would like to use contentbuilder to enter dance competitions.
Each competition has a different view.
All views have some common fields, like FirstName and LastName. Is it possible to pre-fill these fields with the value last entered by the user when adding a record?

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

Pre-fill values when creating new record 4 years 7 months ago #178913

  • lovre's Avatar
  • lovre
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 2667
  • Karma: 76
  • Thanks: 329
Hi,

To pre-fill all the fields with the users last submission values you can use a BreezingForms> Add form menu item with the option "Submission editable by user" set to "yes".

You would just need to create a new CB view based on a "com_breezingforms" type with the earlier created form selected as a data storage.

Hope this helps.
Support Crosstec and get ALL EXTENSIONS and professional support for just $5
Here!
===========================================
Need to renew Pro Support?
Buy Here!
===========================================
Satisfied?
Consider a membership!
===========================================
Like us on Facebook
===========================================

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

Pre-fill values when creating new record 4 years 7 months ago #178979

  • Topic Author
  • mvanderkruk
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 14
  • Thanks: 0
Is there a way to do this without using Breezingforms as data storage. I have some issues exporting the data when using breezingforms as data storage, because of large forms and many submissions.

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

Pre-fill values when creating new record 4 years 7 months ago #178991

  • lovre's Avatar
  • lovre
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 2667
  • Karma: 76
  • Thanks: 329
Hi,

It is possible to use a ContentBuilder> Latest menu item type and then edit the last submission, but this will just edit the existing record, not add a new one.
Support Crosstec and get ALL EXTENSIONS and professional support for just $5
Here!
===========================================
Need to renew Pro Support?
Buy Here!
===========================================
Satisfied?
Consider a membership!
===========================================
Like us on Facebook
===========================================

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

Pre-fill values when creating new record 4 years 7 months ago #179028

  • Topic Author
  • mvanderkruk
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 14
  • Thanks: 0
When I use the breezingforms form I created with the option "submission editable by user" as a storage source for the CB view. I do not have any pre-filled fields in the CB view.
I cannot use the breezingform form itself because I do not want to display all the options in each view.

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

Pre-fill values when creating new record 4 years 7 months ago #179030

  • Topic Author
  • mvanderkruk
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 14
  • Thanks: 0
Also trying a different way now:
I have created a different CB datastore and view.
This store contains the data to be prefilled.

When I add the following to the editable prepare tab, the code is not executed. The query is not recorded by the mysql query log.
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->SELECT Voornaam_Heer 
$query->FROM `xrj5b_danspaaaaaar` 
$query->WHERE user_id='178'
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach( $rows as $row ) {
	$this_Voornaam_Heer = $row->Voornaam_Heer;
}
$items["Voornaam_Heer"]["value"] = $this_Voornaam_Heer;

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

  • Page:
  • 1
  • 2
Time to create page: 0.053 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!