How to make form fields links

[nofue]

Given a large form with fields like email, website, phone, … displayed I'd like to initiate an action on such communications channels, i.e. open the site. send an email, dial the number … as the field "homepage" hold the URL already, it shouldn't be too difficult to put a button close to the field, but so far I haven't seen anything like this yet. Any hints?

[lovasoa]

Hi ! If I understand your question correctly, you want your users to see a form with a pre-filled email field, and next to that field, a button to write an email to the address specified in it ?

You could do that using the description_md property of the form component, using markdown to create a link:

select 'form' as component;
SELECT
    'email' as name,
    email as value,
    'Contact [' || email || '](mailto:' || email || ')' AS description_md
from users where id = $id;

[nofue]

Sweet. Thank you.

[nofue]

I tried my best, but haven't been successful with this example:

select 'form' as component;
SELECT
    'email' as name,
    email as value,
    'Contact [' || email || '](mailto:' || email || ')' AS description_md,
    'envelope' AS icon
from users where id = $id;

My code fetches email from the database:

select	'email'		as name
	,	'E-Mail'		as label
	,	5			as width
	,	'Kontakt '		as description
	,	(SELECT email FROM prospects 
	  	WHERE prospect_id = $prospect_id::int) AS value
    ;

This works as advertised. However, I can't figure how to put the description_md properly.
When I put your line, 'email' expectedly causes an error.
However, when I replace 'email' with a statement to fetch 'email' from the current record like so:

'Contact [' || (SELECT email FROM prospects WHERE prospect_id = $prospect_id::int) || '] (mailto:' || (SELECT email FROM prospects WHERE prospect_id = $prospect_id::int) || ')' AS description_md

nothing happens (visually) -- no error, but no description either.

And this line
'envelope' AS icon
isn't documented in either description nor description_md. Makes me wonder if this is supposed to work or if it's a left over from some other component …

[lovasoa]

Hi !

Indeed, the icon property was there by mistake.

Just replacing email with (SELECT email FROM prospects WHERE prospect_id = $prospect_id::int) should work, but its easier to just put it like this:

select	'email'		as name
	,	'E-Mail'		as label
	,	5			as width
	,	email AS value
	,	'Contact [' || email || '](mailto:' || email || ')' AS description_md
FROM prospects 
	  	WHERE prospect_id = $prospect_id::int
  ;

[lovasoa]

[nofue]

Sadly, the result is the same as when I put the query in place of email: The description_md doesn't show:

Version:
SQLPage v0.30.1 / Mac

[nofue]

Sure I can. But this is not what I want to achieve. Here's an Example as how things look by now:

I replaced "Homepage" with "»", but I can't get rid of the (displayed) URL. This becomes odd when I encounter a homepage with plenty of parameters and UUIDs -- I just want to hide all the shebang behind a single term, such as "»", instead of giving the same address as seen in the line above.

[lovasoa]

Oh, sorry for the misunderstanding. I think what you want is

'[Contact](mailto:' || email || ')' AS description_md

[nofue]

Thanks -- silly me, I could have guessed it. But to my excuse, there are days …
However, this app comes along nicely, and I learn more sqlpage by the day. It's an awesome system that's for sure.

[lovasoa]

If you need more info about the markdown syntax you can use in the various *_md properties of SQLPage components, here is a comprehensive guide: https://github.github.com/gfm/

[nofue]

Thank you very much -- these new (he) *_md properties already caught my interest. Maybe this guide is a bit too comprehensive for my constrained schedule, but hey, I'll put the link to have it ready whenever I might need it.