I have a database holding records of individuals. Only administrators will update/create/delete records but they will be viewable externally via a URL link from a Facebook private group.
I would like to place a mailto link on each record which, when clicked, will send me an email using the users own device email client. This should show up as a clickable link e.g “Wrong/missing information? Email us!”
Using a description field I can get an email address to display as a link but there seems to be no way I can customise it to show a string instead of the address (and subsequently populate the Subject with the record ID and appropriate string).
I have looked at using Actions instead and I can get very close to what I require using the Send Custom Email but then there’s no way for a user to actually then enter or edit data in the email Body before it’s sent which defeats the object.
How might I add an easy way for viewers to email me about a problem with a record which also identifies the record in the Subject and what the sender suggests needs changing in the body of the email?
An alternative I thought about was to create another sheet for updates/amendments then use the a URL action to redirect to the add form for this sheet, however, I’m unable to work out the correct URL to take me to the ‘add’ form instead of the list view.
Any help/suggestions appreciated.