Jasi_au
Forum Replies Created
-
Hi Michael,
I got it working now. It was the wrong kind of quotes causing the issue. Everything works perfectly so thank you very much for that.
Sorry Michael I should have explained myself better.
The headers in the table remain the same even though I’ve used the headers element to map new names e.g. I renamed 2_1 to Title but it doesn’t change in my table as Title. it still shows up as 2_1. Below is the code that I’m using.
[cfdb-table form=”Enfold” headers=”2_1=Title, 3_1=Surname,4_1=FirstName,5_1=Address,6_1=Suburb,7_1=State,8_1=Postcode,1_1=Email,9_1=Phone,subject_1=TourName” show=”Submitted,2_1,3_1,4_1,5_1,6_1,7_1,8_1,1_1,9_1″]
When I try it to add the headers element to the export link shortcode the link doesn’t show up. I guess the question in this instance is if the ‘headers’ element can be applied to excel sheets on export? Below is the code:
[cfdb-export-link form=”Enfold” enc=”xlsx” show=”Submitted,2_1,3_1,4_1,5_1,6_1,7_1,8_1,1_1,9_1″ headers=”2_1=Title, 3_1=Surname,4_1=FirstName,5_1=Address,6_1=Suburb,7_1=State,8_1=Postcode,1_1=Email,9_1=Phone,subject_1=TourName”]
I did notice a <b></b> tag and deleted it out but it still doesn’t seem to work. Would you have any ideas as to what I could be doing wrong or what can and can’t be used in the shortcodes?
Just one more thing Michael,
I’ve added the shortcode element ‘headers’ but it doesn’t seem to be working (please see the code below). Have I overlooked something here?
[cfdb-export-link form=”Enfold” enc=”xlsx” headers=”2_1=Title,3_1=Surname,4_1=First Name,5_1=Address,6_1=Suburb,7_1=State,8_1=Postcode,1_1=Email,9_1=Phone,subject_1=Tour Name” show=”Submitted,2_1,3_1,4_1,5_1,6_1,7_1,8_1,1_1,9_1″]
Thanks Michael that’s working perfectly now.
Hi again Michael,
The shortcodes are working well however I seem to be having difficulty for the columns to be sorted using the ‘orderby’ shortcode for export to an excel sheet. The columns seem to default to the original form column layout which I’m trying to avoid. This is the code I’m currently using [cfdb-export-link form=”Enfold” enc=”xlsx” orderby=”Submitted,2_1,3_1,4_1,5_1,6_1,7_1,8_1,1_1,9_1″] with the orderby values being the column headers in my form. Any ideas what I might be doing wrong?
Thank you for that. Will look into it further.
Hi Michael,
Thanks for your reply. Just one other question. When setting the shortcode and using “show” can this then be exported as an excel sheet in the order set with the shortcode?
Forum: Plugins
In reply to: [CONTACT FORM 7]: How to pass data to one CF7 field to another CF7 fieldHey thanks for that. Very helpful info.
Jasi_au
Forum: Plugins
In reply to: [CONTACT FORM 7]: How to pass data to one CF7 field to another CF7 fieldHI squeaky,
After posting my message and not getting any results I was determined to find some kind of solution. I did find something that helped though ended up using a different concept for the site i.e. information contained in a url link populating a text field. I don’t know if this is what you’re looking for but below is a link to the site that I used to setup this up.
http://www.featheredowl.com/auto-populate-contact-form-7-input-fields-with-url-parameter/
You’ll also need to install the Contact Form 7 Dynamic Text Extension plugin to make it work.
Forum: Plugins
In reply to: [CONTACT FORM 7]: How to pass data to one CF7 field to another CF7 fieldHi there,
I also would like to know if data can be passed from one form to another using contact form 7. The design I have in mind is such:-
Form One would have a submit button that would populate a text field in Form Two with the page title. The idea is for customers to click an enquiry button from a product page (ie Form One) that would bring up another form (ie Form Two) with the page title already filled out in a text field. The reason this is required is because the products are code based and can become quite long and it would be difficult for customers to remember the codes but it would make life easier for the supplier to respond to enquiries by code names. Any advice or direction would be greatly appreciated. Hope someone can help!