Add custom input field

For those people who don't know html, I have a workaround solution. I created a custom view from my original table, modified the sql to include dummy fields like below. Then I can muniplinate the values in the usual way. Finally in the Before Record Updated event, I added lines to unset the dummy fields or simply return false to unsave all changes.

SELECT
report_id,
name,
YEAR(GETDATE()) as [Year],
getdate() as [FrDate],
getdate() as [ToDate]
FROM dbo.gl_report_h