Select form field | Community
Skip to main content
LeaCharnley
New Participant
March 13, 2024
Solved

Select form field

  • March 13, 2024
  • 3 replies
  • 6488 views

Hi

I have added a select field to my form, and I created a custom field in the database to record the information to.

The selection is for the customer to choose a session date/time for an event.

I want the recorded info to be passed via a token to an alert email and a thank you for registering email. 

The database field type is text, but the selection isn't recording in the database, and therefore not being passed to the emails.

Any ideas what I might be doing wrong?

Here is the form link: https://visit.altro.com/adhesive-free-roadshow.html

Thanks

Best answer by Darshil_Shah1

That is very odd. If I open a preview or draft of the form it shows the mkto_CommentCapture field, but if I open the landing page it shows the appointmentDateAndTime field. Very strange indeed!


@leacharnley , did you approve the LP after approving the form? This is required if the form is added via the Form Element on the Marketo landing page.

3 replies

Jo_Pitts1
Community Manager
March 13, 2024

@leacharnley ,

really obvious question (mostly prompted by the order of operations you've described).


@leacharnley wrote:

I have added a select field to my form, and I created a custom field in the database to record the information to.

Is the select field set to put it's data into the custom field.  I only ask because if you added the select field and then added the custom field, you'd have had to go back and redo the select field. 

 

If that's just the way you wrote it as opposed to the way you did it, it's still worth confirming that the field you think the data is going into is in fact the correct field.

I agree with @sanfordwhiteman, let's see the form fill details for the lead email he supplied.

 

Cheers

Jo

LeaCharnley
New Participant
March 19, 2024

@jo_pitts1 - I have attached the filled out form activity to Sandford's message.

Lea Charnley
LeaCharnley
New Participant
March 19, 2024

@jo_pitts1 @sanfordwhiteman @darshil_shah1 @saurabhgoyal_gn 

Hi all

I thought I'd try writing my responses to the mkto_CommentCapture field as I have some pressure to get this live. It gets somewhat weird here, my logic defines that what is happening, should not be.

I changed the field in the form from the appointmentDateAndTime to mkto_CommentCapture with all the same options on the select field type. 

The responses are not being posted to the mkto_CommentCapture field, but to the appointmentDatAndTime field, even though that is not what is now in the form. 

It takes a lot to baffle me, but I have no clue why or how this is working!

Lea Charnley
Darshil_Shah1
Community Manager
March 13, 2024

We can't access the Marketo form link as we don't have access to your Marketo instance. Can you share the URL of the webpage where you've deployed your form? Also, are you able to see the data submitted against the field in the Filled out Form activity (i.e., when you expand the activity in person Activity Log)?) Lastly, why are you using a text field to record date-time data? Marketo supports fields with datetime datatype, and you'd be able to use the DateTime operators filters, flow conditions, etc., which you'd not be able to for a text field.

LeaCharnley
New Participant
March 13, 2024

I've updated the link.

I'm not recording it as a date:time selection, as there is venue location included, which is why I chose text. I am not seeing the data being recorded in the Filled out form activity.

Lea Charnley
SaurabhGoyal_GN
New Participant
March 13, 2024

@leacharnley - I had a look on the URL you shared. By inspecting I can see one issue, In dropdown values, in this option "Tuesday 23 April - Kennedy Flooring - 08:30-11:00" there is no store value. Please have a look o the screenshot given below. 


 


If you will submit the form by selecting other options from dropdown then you should get values in your marketo database. 

SaurabhGoyal_GN
New Participant
March 13, 2024

@leacharnley - 

Nobody will be able to access the given link untill and unless they are a user of the account. 

Do you have a LP or webpage where the same form is hosted? If yes please share the URL. 

Otherwise it would be great if you can check display values and stored values and may be you can share the screenshot here. 

LeaCharnley
New Participant
March 13, 2024

Sorry - of course! It's here. https://visit.altro.com/adhesive-free-roadshow.html

The display/server values look like this:

Tuesday 23 April - Kennedy Flooring - 08:30-11:00|Tuesday 23 April - Kennedy Flooring - 08:30-11:00
Wednesday 24 April - Kennedy Flooring - 08:30-11:00|Wednesday 24 April - Kennedy Flooring - 08:30-11:00
Thursday 25 April - Flanagan Flooring Distributors - 08:00-10:00|Thursday 25 April - Flanagan Flooring Distributors - 08:00-10:00

Lea Charnley