Forms that trigger updates - workaround for making those fields required
1) We use a form to collect required data. From there, one question triggers an update request to a third party from the email that we collected in the form. We want these fields to be required. As a workaround, I tried using the same workflow to set a condition that if any are left blank, then to request a secondary update. However, when we tried this, both emails arrive at the same time, one asking for an update, the other saying the update was incomplete. How do I trigger the update to the update? Separate workflow altogether? Instructions would be great.
2) The other issue is, at the footer for the email is "go to sheet". We don't want them to have access to whole sheet, just that they "open request".