I have two tables, one is customers and the other is jobs. These are linked by a relation through a Customer Number column. New jobs automatically populate in the jobs table (a google sheet) through a zap from a pipeline software once they are put into a specific status. What I want to do is:
When the new job shows up in my glide app it will appear in a filtered list in the UI (filtered to show only those jobs where Customer Number is empty) - I have that already set up
When the user clicks on that job in the list an overlay opens - I have that set up
They should be able to search a list of existing customers within a table in the overlay - I have that set up
Now what I want to do is for them to be able to select the customer that they want this job to be associated with and add the Customer Number from that customer into the Customer Number field within the job record. - THIS IS WHAT I NEED HELP WITH.
Any suggestions of how I could do this? If there is an easier way for the entire workflow I am all ears. Except that I cannot change the fact that the jobs are imported from the pipeline software to the google sheet, that is not optional.