Form support is touted on the homepage: https://www.getgrist.com/forms/

For what it's worth, which isn't much because this is probably outdated: I remember trying grist a few years ago and leaving mildly unimpressed with form support (I think because I was hoping to have image upload in the forms and that wasn't supported yet).

I'm not an MS dev type, but I've often seen these forms questions. What made their forms so easy, or more in general what is so complicated about forms that this was even a tool so many liked?

If you want forms try https://visualdb.com/ it is another tool that aims to be Microsoft Access