Required column forces column in automation test to become required as well.

[ConorWebb96]

Checklist

• [x] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.13.52
  • App Version: 2.13.52

Describe the bug Whenever trying to test an automation and a column is required in the data area, even if you fill in all the information from the testing automation modal. You won't be able to progress unless you add a value to the automation step itself. This shouldn't be necessary on a create row step. As the row will be created before it hits the automation step meaning that the row required fields will already have a value before they are passed along.

To Reproduce Steps to reproduce the behavior:

1. Go to a on create automation
2. Add a update row step
3. Bind up properly, leave the require field in here blank as it should already be filled before being passed along
4. Add data to the test automation modal
5. Run the automation, see error.

Expected behavior Automation should run without hitting the required validation

App Export birthday-export-1704185052328.tar.gz

Desktop (please complete the following information):

• OS: Mac OS
• Browser: Brave
• Version: v1.61.109

[linear[bot]]

BUDI-7866 Require column forces column in automation test to become required as well.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had any activity for six months.