as the title states, I wish to create a Search bar which will return the values from a GSheet(2) tab but also wish to be able to input data to a separate tab(1) on the GSheet in order to add it’s data to Tab(2).
I have tried copying Muneer’s suggestions and apps but unfortunately, they just list my whole spreadsheet without filtering the search criteria (ie inputted text into my Input box).
I am very new to Thunkable and have tried to start my first project which is to be multi-screened app for aviation enthusiasts. I intend to eventually make this into an app for my private aviation group.
What I am looking to create is an app which not only will supply reference data from my pre-created Google spreadsheets but on certain screens will allow members to input data also. On other screens there will be embedded info like maps, chat or photos.
The page I am currently trying set up is a data page called “MAN First Visits”. I currently have a Google Sheet tab (“FV”) containing close to 2,000 records and rising. Each record has 7 columns. Data in this sheet is entered via another tab called “FVENTRYFORM”. This allows data records to be entered by members which is then converted into an alphabetised, uppercase format which is displayed in the FV tab.
- I wish to display and return the FV tab within Thunkable on my “MAN First Visits” screen using a text input box for data searching. This will then return the full 7 columns for each record returned.
The Data Viewer List (DVL) doesn’t seem to allow me to display my desired 7 columns and none of the tutorial videos seem to show me how to do this or create the filtered search. Could some kind soul explain to me in layman’s terms how this could be achieved?
- With reference to input part of my problem, I would like to be able to create an input screen which allow myself and members to be able to enter/create; amend/update; and delete records from the “FVENTRYFORM” tab.
I must also mention that all the columns have headers and sub-headers:
"REG"; "C/N"; "TYPE"; "DATE"; "CALLSIGN"; "FRAME/REG"; & "REMARKS" respectively. https://docs.google.com/spreadsheets/d/1fsyPJ5vfrzw1EdoxDMZ0fB_S_YB0rUrjpEvNahjPZ8Y/edit#gid=0&range=A1:G2
The “FVENTRYFORM” TAB mirrors the “FV” tab exactly and all records start on row3 in both tabs because of a required format for my website
This is the link to my app. I hope I’ve done this correctly:
If you have any questions regarding details I may have not supplied, please let me know.