I have created an app for generating a travel request for a particular project, which the authorities can approve or reject. The form has two columns [Project No] and [Project Title]. Every Project Title has been assigned a specific Project No. This data is present in a seperate spreadsheet named “Project Data”.
I am trying that whenever the [Project No] is entered, the column [Project Title] should automatically be filled based on that Project Data spreadsheet.
I am new to AppSheet and trying to figure out this.
Kindly help me through this.