You have several options. You can use a ‘Show Detail Screen’, ‘Show New Screen’, ‘Show Edit Screen’ action on the button to get a screen attached to the same row. The Edit Screen will have a submit button, but Detail Screen and New Screen, will update records in real time without the need for a submit button…unless you are making a custom edit screen and build in some logic to set values using a Set Column action.
What you have seems fine. When you click on the Edit button, it brings up the Edit screen and you can add any components you want to that screen. You can add components to show existing information as well as component to enter additional information. So, I think you are there, you just need to modify that edit screen you showed in your video.
You don’t do it in the form, you do it in the action that opens the form.
So if you’re using a custom form, you probably have an action that does either “Show Detail Screen” or “Show New Screen” to open your form. What you should do is change that to a custom action with two steps. The first step will clear the form columns, and the second step will open it.
I’m lost on what you are trying to do, but here is what I’m seeing in your last video. It appears that your table has an existing row. When you open your form (which is actually a detail screen connected to that existing row…aka ‘Custom Form’), you are updating that row in real time as you type. Your submit button technically isn’t doing much of anything anything, like adding a row. All it’s doing is clearing all of the columns you just filled in. I don’t see any Add Row action, or anything that would take those values you entered and write them to a new row or different columns in the same row. What your submit button is set up to do is literally clear everything you just filled in for that row. If your intention is to add a new row, then you need an Add Row action before clearing everything. You have a custom form, so it works differently from a native form which always adds a row. In this case, you have to explicitly add the add row action.
Now if I misunderstood and you actually do want to update the current row and clear values in that same row, then maybe you need two sets of columns. One set that gets filled by the user on the screen, and a second set that gets filled after the button is pressed, which moves the values from the first set of columns to the second set of columns before clearing the first set of columns. I’m not sure if I’m understanding your goal. It would most likely make more sense to use an Edit screen to update data in an existing row, but it seems that you want a different experience. I guess I don’t understand why you would want to update values in a row, but not see the values you just updated in your form after you submit it, just to fill the form with new values that will overwrite what you had previously submitted to the same row. Just not understanding your goal, so maybe we are headed down a rabbit hole.