I am currently creating an application that will allow users to send messages and “flowers” to one another . And I want to be able to record the sender, receiver, message and amount of flowers in a excel sheet. I have done this using the “Form” function. However, I would like to allow the sender to send different amount of flowers to multiple users within the form itself. Is that possible?
I have done one version where a " more receiver" can be added via choice function which becomes visible when the first receiver is chosen. But this only allow for one name to be chosen. and the data of the second receiver will be collated in a separate column. Is there a way for them all to be collated in one column so that it will be easier to tabulate the data in the end?
Hope I made sense with what I said