Insert ui input values into database

Is there a way to write an insert query for snowflake that uses the values from a text input? I’m trying to create a form that would take the values from the text inputs and insert it into a database. I saw that there is a way to write queries using dynamic values, but I haven’t been able to get that to work in this case.