TOPIC:

Submitted form ID 2 weeks 5 hours ago #245976

  • Topic Author
  • deeplogica
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 42
  • Thanks: 0
I think the question is actually at what point are all the elements stored?
Does this occur in the after form or submit pieces etc? Once we know when EVERYTHING is safely stored, at that point I can pass the variable to my query. Doesnt matter where its stored. can be a hidden input, as long as I have access to it and can call my query at the appropriate time.

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

Submitted form ID 1 week 6 days ago #246022

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9789
  • Karma: 167
  • Thanks: 785
Hi,

it is stored in #__facileforms_records. There you have the "form" column that the record refers to, it will be the form id. Ordering by id would give you the latest in your query.

You can also store the last form id for which a record happened in a session variable. That you would do in form => advanced => more options => submit pieces => end submit => custom.

Example:
JFactory::getSession()->set("last_form_id", $this->form);

You could re-use this session value anywhere on the site then by retrieving it using

JFactory::getSession()->get("last_form_id", 0)

Regards,
Markus

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

Last edit: Post by TheMuffinMan.

Submitted form ID 1 week 6 days ago #246024

  • Topic Author
  • deeplogica
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 42
  • Thanks: 0
Hi
Yes I know where it is stored, however I think you are misunderstanding.
I need to call a stored procedure in the database which will use the form id AND all its elements. However currently, what is happening is the process runs, however the submitted form has not yet completely written all its records to the elements table, so I am missing data.
Thats why I need to be able to run my procedure after the submission has completely written ALL the data to the elements table.
At the moment the event seems to trigger when the form is submitted, but not necessarily after all elements have been written.

Hope this is clearer

thanks

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

Submitted form ID 1 week 6 days ago #246040

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9789
  • Karma: 167
  • Thanks: 785
Ok, I understood it now but everything should be stored using an end submit piece and that's exactly the spot where you would call your procedure.

I am not sure what you see missing there or what am still missing but the table inserts and updates are basic and there is basically no asynch behavior involved that would fire after the end submit event is called.

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

Submitted form ID 1 week 3 days ago #246201

  • Topic Author
  • deeplogica
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 42
  • Thanks: 0
Ok, let me try again.

thanks

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

Submitted form ID 1 week 2 days ago #246216

  • Topic Author
  • deeplogica
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 42
  • Thanks: 0
Hi
Im still having a problem:
this is my code:
$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
$user = JFactory::getUser();//Get user Object

$session = JFactory::getSession();
$sessionid = $session->getId();
echo 'id = '.$sessionid;

ff_setValue('mysession', $sessionid);

$url = (isset($_SERVER) && $_SERVER === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

$url_components = parse_url($url);
parse_str($url_components, $params);


$assessor = $params;

ff_setValue('assessee', $assessee);


So I am getting the session id - and rhe echo shows a correct value.
However I am trying to store this in a hidden field which should be written to the database on submit, but nothing gets stored.

not sure what I am doing wrong because the assessee field is stored perfectly. All this code is in the Before Form Piece. assessee is a hidden field also.

thanks

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

Moderators: ForumSupport
Time to create page: 0.043 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

Summer Sale!

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!