julesmd

Hi Michael,
I’ve had a re-think about this…
Would it be possible to use Add Link to Entry in CF7 Email for what I am trying to achieve? I don’t understand how to use it, but it might be what I need.
I need a link from the details page to an email form. This must get the recipients data from CFDB (using submit_time) and only display the recipients username held in CFDB (email should not be visible and the sender is the logged in user).
Here’s a link to the website website (you will have to click on ‘View Details’ to see the ‘Contact’ button). This will show you what I am trying to do.
Could you have a look at this for me if I send you my log-in?
Many thanks

Sorry for the bad explanation.
My users are registered in WordPress before submitting data via CF7. With the messaging system I am using (which uses WordPress user data) I can dynamically enter Usernames in the To field, except when using it in conjunction with CFDB. I understand that CFDB will always put the same person as the Author (it is always admin), therefore I get the messages, the user (Author) doesn’t. In WP if a user submits data they are recognised as having a post and are therefore an Author.
As submit_time is a unique identifier I wondered if there was any way to match submit_time with the WP Author role/username?
I’m not sure how changing form data before it is saved could work, unless it could pass the submit_time data to the WP database?

Sorry! Marked as resolved

Sorry, that was a mess. Here’s the html code again:

[start_end_wrapper shortcode="cfdb-html" form="Sign Up" show="Country,City,AccommType,start,end,Event,Interests,MainImage,submit_time" filelinks="url" role="Anyone" filter="Country~~/.*$_POST(country).*/i&&City~~/.*$_POST(city).*/i&&AccommType~~/.*$_POST(accommtype).*/i&&Event~~/.*$_POST(event).*/i&&Interests~~/.*$_POST(interests).*/i"]
<table>
<tbody>
<thead>
<th></th>
<th>Country</th>
<th>City</th>
<th>Accommodation</th>
<th>Available</th>
<th>Specific Event</th>
<th>Interests</th>
<th></th>
</tr>
<tr><td><img style="width: 100px; height: 100px; border: 0;" src="${MainImage}" alt="" /></td>
<td>${Country}</td>
<td>${City}</td>
<td>${AccommType}</td>
<td>From: ${start}
To: ${end}</td>
<td>${Event}</td>
<td>${Interests}</td>
<td><img src="http://freestayexchange.com/wp-content/uploads/2014/12/details_button.png" alt="" /></td>
</tr>
</thead>
</tbody>
</table>
<hr />

Please can you tell me if the code you wrote for the date search will only work with cfdb-table, and if not where am I going wrong.
Many thanks
Julie

Thank you!!!!! You’re a life saver.
It’s perfect. What was wrong?

This is what is in the post under ‘text’ in the WP editor.

<form action="" method="POST">
Start: <input type="text" name="start" />
End: <input type="text" name="end" />
<input type="submit" />
</form>
[start_end_wrapper shortcode="cfdb-table" form="start_end" show="start,end"]

The lines containing filter=”&&&&&&&&&&” and filter=”” are appearing on the published page.

Thank you. I’ve created the shortcode again and made a new post but it still doesn’t work! This is what appears on the page (under the form) when it is published:

[cfdb-table form=”start_end” show=”start,end” filter=””][ form=”start_end” show=”start,end” filter=”&&”][ form=”start_end” show=”start,end” filter=”&&&&”][ form=”start_end” show=”start,end” filter=”&&&&&&”][ form=”start_end” show=”start,end” filter=”&&&&&&&&”][ form=”start_end” show=”start,end” filter=”&&&&&&&&&&”][ form=”start_end” show=”start,end” filter=”&&&&&&&&&&&&”]

Does it give you any clues as to what could be wrong?