I want to achieve a really clean, modern form that doesn't have column labels (where possible) - I know inserting 'default value' will display the text in the column but it doesn't delete the whole value when the user clicks in the column to enter their data, so it's not a great user experience.
Is this possible?
This is how I want it to look, but preferably greyed out text that disappears when column is clicked on to edit.
this is not yet supported as a product feature. There is a uservoice thread about it that you could vote for:
Besides this there was a thread about this topic that at least gives some alternatives until the feature makes it into the product:
Hope this is still a bit of help.