I think what you need here is a custom form. You can have that lookup value in advance to execute an add row function and then a set column action if I understand you right.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| 🚀 Actions on FORM SUBMISSION! | 67 | 4920 | March 8, 2024 | |
| Multi-step form | 19 | 3799 | July 14, 2023 | |
| Form submission criteria | 2 | 742 | March 15, 2022 | |
| How to avoid to add a row after submitting a form | 3 | 406 | July 14, 2023 | |
| Duplicate rows | 4 | 242 | January 29, 2024 |