I am using varchar for the field type for websites and email addresses. Is this the best field type to use?
There is no special field for E-Mail or websites. Only text will be saved in the database. So VARCHAR will be the best solution for this.
If you will use this field for starting websites of starting the mail program you will need a macro. It won’t start automatically like web or mail addresses in Calc.
SInce you mention email, you’ve got to add the protocol prefix mailto: (unliess it is already stored like that):
SELECT *, 'mailto:' || "EMAIL"AS "mail_url" FROM "Your Table"
Adjust “EMAIL” and “Your Table” to the actual names of your column and table. The query selects all columns from your table plus an additional column “mail_url” with the mailto: prefix in front of the column named “EMAIL”.
Link your form to this query instead of the table, add your push button to the form, enter “mail_url” in the “Additional Info” property, assign the “Approve Action” event to my previously installed macro.
1 Like