Maybe I'm missing something, but is there a good way to link the webforms and the orders together? I don't see how one would know what webform submission goes with which order.

Comments

andyf’s picture

andyf commented
Status: Active » Postponed (maintainer needs more info)

Hi,

Sorry for the delay. The webform submission ID's stored with the Ubercart order, but it's not currently accessible via the GUI. Could you expand on your use case, or how you'd like it to work?

andyf’s picture

andyf commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)
adammichaelroach’s picture

adammichaelroach commented
Status: Closed (works as designed) » Active

What I was looking to do was create a view that showed each order that was made, and then show the data from the webform submission that coincides with each order.

andyf’s picture

andyf commented
Title: Linking Webforms and Orders » Create Views relationship linking order to webform submitted data
Version: 6.x-1.3 » 6.x-1.x-dev
Category: support » feature
Status: Active » Postponed

Hi,

I'm not sure that Webform itself exposes its submission data to Views yet (see #680386: Views integration for the webform_submitted_data table). If time's available I could look into this further once that issue's committed, or will happily accept patches in the meantime :)

warpedrive’s picture

warpedrive commented

Having the same issue, I think:

Our site admins want to see / click through to the order # that was placed as part of the submission / checkout process.. right now, I can see if they paid, but there is no link to the order...

How am I supposed to see / find the order, the amount they paid and so on..? Easiest would be simply including the order id as a field in the form elements, to link back..?

Any thoughts? Am I missing something?

andyf’s picture

andyf commented

Yeah, that's a definite area for improvement. The webform submission ID's stored with the order, so it's all possible (see #1164250: update webform submissions with uc_order_id and uid comment 2 for details). This issue has morphed into a Views request, so I've opened a new one for you: #1496376: Create link to submission from order and vice versa.