Hi, I'm brand new to AppSheet, fairly new to Sheets. I have been an Excel guy since I moved from Lotus123 for DOS back in the late 80's. anyway, I have done quite a bit of coding in Excel, I'd say I was mid-level because I still have to look up syntax sometimes. I have a Sheets workbook with currently 5 tabs. My question deals with 1 sheet that is related to one of the other sheets. I have things like I want them and can use filters on Sheets to do what I want, but thought how could would it be to view the data from an app (don't really have a need to edit on the app, just view) on my phone rather than scrolling every which way and zooming in sheets. It's a sheet for listing our puppies. The sheet has 7 columns of info. Column A is basically a unique ID for the pup, and column B is an id for the litter itself, which is basically a shortened version of column A ex: Column A = GJ121623F7M11MYellow column B would be GJ121623F7M1. So 1 litterID could cover 1-8 pups and each pup in that litter would have a unique ID. Column C is the date they were born, columns D&E are Mom and Dad. columns D&E have data validation so that you can only enter names of our dogs from the family sheet. (to avoid data inconsistencies don't want to be able to put in a dog we don't have or misspell it.)
I have a view that shows the family and got it sorted the way I want it with basic info and showing the details if you click on one.
now I would like a second view for the litter info. Being new to this I don't kow if it's even possible or I'm running down an endless rabbit hole. I would like the view to be three options like either dropdowns or buttons. I think maybe one would be better as a drop down and the others maybe buttons. I would like to filter data from the Litters sheet based one any 1 or combination of the 3. First dropdown would be retrieved from column C (Date), second (maybe) Button column D (mom), third Button column E (dad) and I guess a SEARCH (action) button at the bottom. Selecting a date would show you the litters only from that date. or search for any by mom, or mom and dad etc.. Basically when you hit search, it would return any litter ID that matched the criteria (but only one instance of that ID) you then select the litterID and it would return all pups details associated with that group.
(again I'm new to this and the sheet is probably not set up the most efficient way for an app, I set it up as I would a Sheet with using filters.)
I found an article or two using the "search the group" function that seemed like they might be pointing me in the right direction, but they both mention the use of code. I can't find any way to add or edit code in AppSheet.
TIA
LinkedIn
Twitter
