Hello gliders, my users select a product in a form from a product list database called “references” :
Then, by submitting, their selection is saved in another database called “Product items” :
I want the submittion save product ID (column “Référence”) in the meantime, while this data is not in the form screen :
Do you have any idea of how to do it?
I thought about solutions but without knowing how to do, like :
- A hidden field in the form screen that autocomplete Product ID while select it
- Using Set column values after submission
- Using something quite like Relation column type
In any way, I need then to display this Product ID in the app