Create a new row but use another sheet's data as presets

  • Start with a Collection that uses your “Preset” table as the source
  • User Selects an item in the Collection. The default action will take them to the details screen for the selected row
  • Add a button to this screen with an Open Form Screen action. You should now have direct access to all values in all columns of the selected row to use as column values in your form.

I recommend the below video: