I did this for several clients, and usually I built an abstraction atop the actual data table.
By that, I mean I made a dedicated single-row table with all the inputs, a validation formula that returns T/F, a validation message, and a button that copies data from the form into the data table and is only enabled when the form is valid.
Where it was less critical, I didnāt make an abstraction but simply provided a validation message + some indication (e.g. red background via conditional formatting) that some data was invalid or missing.
You could fake a āSubmit Bugā button that could check a checkbox column. If you set this button as disabled if certain fields are empty, it gives the illusion that the bug isnāt submitted. A table could be filtered to āBugs not submitted yetā or an automation could run every morning that sends a reminder to the creator of the row that some fields are empty.
Even if there are workarounds, I think that there is opportunity for the Coda team to implement a feature that solves this issue at the core and makes it easier for Coda makers to create doc-apps.
I usually use @Paul_Danyliuk method - an input table/form with a button that copy the data to the āmainā table and is disabled if the required fields are empty or have incorrect data type (e.g - text instead of numbers).
I like to use detail view to give it a form-like feel but unfortunately conditional formating doesnāt work there Conditional formatting visible in card and detail view so I list the missing fields in the validation message.
I might share an example in a few hours, whan Iām back at my computer.
Hereās an example
This is part of a doc Iām currently working on for my research lab (Iām a student), to track order_requests-purchases-inventory (the doc is still under construction - any suggestions are welcome )
This is a big need of mine, too. Similar use as @Raul_San_N.H you are describing - I have a lot of need for Coda that your excellent templates in the gallery are more or less designed to fill - bug tracking, lining up user feedback and cataloging to certain missing features, and a few others.
I think a good analogy here is when you fill in webforms in your everyday use of the internet, in particular shopping carts or sign ups on apps, you will frequently not be able to complete the process if certain fields are not filled out. They turn āredā at times when you hit āsubmitā so the user can go back and complete them.
And one particular way to use this that would be very helpful is to force a comment to be added to a row when an action is taken. Ideally the row would be set up for the comments window to āpop upā and require a comment before completing the action. This is very useful in the case of processes being run in Coda: You might require a comment when the status is moved to ādoneā or ācomplete.ā If you have a column for āstatus,ā and you could with automation require a comment before the final status was accepted, youād have a very powerful feature for end users to easily remember to notate what they actually did to close out a process.
One more vote for this one! Itās a really a much needed functionality. The input forms also work, but itās a lot of work if you add or remove fields from the table. Would love to see this functionality!
This would also allow us to move away from Google Forms for sign-ups, feedback, and such.
Actually, if you are concerned about the forms: coda forms has required fields. I havenāt used a google forms form for years.
I am not saying we couldnāt use some more options for Coda forms, but required fields works just fine.
Is there any development for required fields in Detail view?
The best I could think of is Button (Open row) > Canvas row in dummy table > Embedded link to a published form in the canvas row. Works, but is kind of clumsy because of the sizing and all.
Is there any update for this function? I realy need required fields in Detail view and I think its a shame that Coda doesnt have this option. I always thought that is a realy basic function