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