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 | 4923 | March 8, 2024 | |
| Multi-step form | 19 | 3800 | July 14, 2023 | |
| Form submission criteria | 2 | 742 | March 15, 2022 | |
| How to avoid to add a row after submitting a form | 3 | 407 | July 14, 2023 | |
| Duplicate rows | 4 | 243 | January 29, 2024 |