Hi All
I'm wondering if there is a way to insert a hyperlink as a default value either into a column or a web form so the user than click the link but doesn't have to create the link in every row populated by the web form. I see a hyperlink can be added directly to a sheet, but my users aren't happy with that. They're looking for a quick way to assign a task to multiple people and I'm almost there (using a task and assigning via subtasks), but they want to click on the main task and get the form. There would be two forms, one to add a main task and one to add subtasks, each with a different subset of columns.I haven't had any success using HTML as default text.
While I'm at it, is there a way to set a form so that every row created with it is indented? Less important than the above, but would be very useful.
Any help is much appreciated.
Thanks!