I have a google sheet with to sheets, one is Cliente and the other one is Reporte técnico. Using Appsheet, how can I auto fill information from Cliente in Reporte técnico if some of the info is exactly the same. I would like to be able to choose the name of the company from Cliente (It is done) and then automatically fill some data in Reporte técnico, info that will always be the same. For example the name of the contact, the cellphone number, email and address (do not know how to do it).
Need your help. Thank you!