LinkedIn
Twitter
Hey there. I'm pretty new to Appsheet and am not really a programmer. So i'm not 100% sure if my explanation will be sufficient.
I have built a sercive booking/job system in appsheet. This used to be done on a single excel spreadsheet with the first row being the number, then subsequent info like: Make/model, Name, email, issue, etc.
We turned the excel spreadsheet into a google sheet and use appsheet to interface with the google sheet instead of manually putting in data. We used to have to enter in the customers full name, email and phone number for every job and it was very fustrating that the system did not remember any customer details. So I made a separate table within appsheet that looks like this:
โThe data is being inputted to the sheet like this:
Assigning a uniqueid and only showing this in the customer name field.
The column "Customer Name" is a ref to the above table and is set up in appsheet like this:
Set up of the google sheet Customer Name row in Appsheet:
I would like the customer name in the google sheet to show the customer's name and not the uniqueid assigned to that customer's entry in the original table. This is because the system can print labels from the google sheet using a template:
But now the label is showing the customers uniquid instead of the name.
Any help here would be appreciated.
