Select form field

[LeaCharnley]

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

[Jo_Pitts1]

@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]

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

[LeaCharnley]

@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!

[SaurabhGoyal_GN]

@LeaCharnley - 

I noticed that the "mkto_CommentCapture" field is not visible on the form located at this URL: https://visit.altro.com/adhesive-free-roadshow.html.

I agree with @Darshil_Shah1's suggestion to create a new form and a new landing page. If the issue persists, you can raise a ticket with Marketo support.

[LeaCharnley]

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!

[Darshil_Shah1 · Accepted solution]

@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.

[LeaCharnley]

Hi Sandford

Yes, I built and approved the form before I even started building the LP.

[SanfordWhiteman]

Please ensure you do not currently have a draft version of the form or LP.

The behavior you’re describing — where the fields look as expected in draft/preview but not in prod — is consistent with not approving the latest changes.

[Darshil_Shah1]

Well, this is weird. Did you approve the landing page after approving the form (if you added the form via the form element on the LP)? I, too have faced some issues where the obvious thing, like the visibility rule, won’t work as configured. Creating a new form from scratch worked for me. Could you try that and see if that does the trick for you, too? I’d also advise you to raise a support ticket detailing the issue you're seeing with your existing form along with relevant snapshots.

[LeaCharnley]

Hi @Darshil_Shah1 

Yes, I've got an ongoing support ticket live, and have just sent them the same update as I've sent you. I think I'm happy to leave it live as it is now working. But hopefully, they will come back to me with some form of explanation.

[Darshil_Shah1]

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]

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.

[SaurabhGoyal_GN]

@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. 

[LeaCharnley]

I had updated the form, but not published the landing page. 

I have done so, but it is still not recording the information in the database.

[SanfordWhiteman]

Please show the Filled Out Form details for the following lead in your database

  teknkl+test0001@email.invalid

The field was posted as expected for that lead (i.e. the data went on the wire to Marketo).

[LeaCharnley]

Hi @SanfordWhiteman 

Here is the activity - you can see that the appointmentDateAndTime has no data against it

[Darshil_Shah1]

Marketo automatically adds the missing stored value as soon as the Edit field values dialog box is closed, so even if the user hasn't added a stored value, Marketo would add it from its end (including the pipe '|' symbol that separates the display and stored values; with no value provided, the stored value would be the same as the display value). @LeaCharnley, I can see that the payload has the field data for the save2 network call:

Do you still not see the Appointment Date and Time data in the filled-out form activity? Or alternatively, are you able to share the snapshot of the Filled Out Form activity from the person's Activity Log so we can have a look?

[SaurabhGoyal_GN]

@LeaCharnley - Also, I see that none of the field is required on the form. Please mark the needed fields as required including "appointmentDateAndTime".

[SaurabhGoyal_GN]

@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]

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