You are viewing limited content. For full access, please sign in.

Question

Question

Query Forms submission field values with labels

asked on February 6 Show version history

I want to query the forms database and get the submitted field values along with the field labels but when the field is a subfield within an Address field, I am not able to return a label.

Is there an easy way to get the labels for the individual subfields of an address field?

0 0

Answer

SELECTED ANSWER
replied on February 11

Hi Bert, the labels for subfields are stored in [dbo].[members], you can use [member_id] from table [dbo].[cf_bp_dataset] to get them.

1 0

Replies

replied on February 10

Anyone?

0 0
replied on February 11

Thank you @████████ That was exactly what I needed.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.