About mrbonnell

mrbonnell · 11-22-2023

I'm trying to pre-populate a form with LINKTOFORM() that is made when clicking on an inline list.I have 3 tablesTrip Details -Parents have a filtered list of trips their children are going on, they click on the trip and get to a detail viewPeople - t...

mrbonnell · 11-20-2023

Hi All,I would like to filter a dataset based on the [Row ID] (which on its own works just fine) but I'd like to return the data from a specific column [Confirmed Learners] (column type List), then combine the returned lists into a larger list.I'm tr...

mrbonnell · 11-11-2023

Dear Appsheet CommunityI am creating an app to manage trips for my school. There are many trips going out, each of which requires an itinerary, and each itinerary item requires a time and event. (example itinerary below)You can see there are many eve...

mrbonnell · 11-02-2023

Hi AllWe have developed an app to help manage the trips for our school, this was created using Appsheet Database for the backend. There is a limit to 2500 rows in the database so I know we need to upgrade somehow to allow larger datasets.As we are a ...

mrbonnell · 11-21-2023

Hi,With this method the Enumlist is only being populated by the first instance of the list in the table, it is not combining the lists. In my example this would be only {Danny,Clair,John} and not the second list.I think SELECT is only bringing in one...

mrbonnell · 11-17-2023

Thanks again Suvrutt_GurjarI implemented the security filters on all of the tables, it seems to be working correctly still and will be helpful in sync times. Kind regardsMatt

mrbonnell · 11-12-2023

Dear Suvrutt_GurjarThanks for the reply. I think that might work for current data as we might have a couple of hundred trips per year with average 20 itinerary items per trip which hits the low thousands.A potential problem then arises though if we w...

mrbonnell · 11-09-2023

Hi AleksiThanks for the info, seems like I'm going to have to shift and use google sheets for this product then; the cost would be hundreds of thousands of dollars per year just to use the Appsheet Database as my datasource.I'll take a look at the se...

My Stats

mrbonnell's Bio

Badges mrbonnell Earned

Recent Activity

LINKTOFORM with parent and 3 tables

Filtering with combining lists

Complex Lists in single cell

Which type of paid account do we need for our school? Using Appsheet database

Re: Filtering with combining lists

Re: Complex Lists in single cell

Re: Complex Lists in single cell

Re: Which type of paid account do we need for our school? Using Appsheet database