I am wondering how I might get a filtered Google Sheets view into a Grid Iron 3 table under Source. The url has a fvid reference, but there is no obvious way to enter that into the Grid Iron 3 stack inspector. My use case is I have market stall information that I want to display in a table - but only for stallholders coming in a particular month. I use a separate column for each monthly market month of attendance - and a checkbox in that month for each stallholder attending. I have created a sheets filter in the month of June where the checkbox=true — but so far, cannot make Grid Iron show anything but the full table of all my stalls.
You should be able to build a NEW sheet in the same spreadsheet with the updated data. Have you tried writing Functions in Google Sheets to reduce the data?
Hi @barchard thanks for the reply. I realised about an hour ago this was my best option as well.
Hello @barchard my spreadsheet is now working perfectly except I keep getting this error message above my rendered sheet: Deprecated : Required parameter $permissions follows optional parameter $path in /home/strathm2/public_html/mnmarket.strathmorefarm.com.au/rw_common/plugins/stacks/gridiron-3-vendor/tedivm/stash/src/Stash/Utilities.php on line 216 Sounds like I do not have the current version? I have 3.4.5 installed according to RW Cheers DougP
@parked try changing your PHP version to 7.2 or 7.4 to see if the error changes. I’m guessing you’re using PHP8.x?
Hi @barchard - thanks Greg, I just wanted to close the loop on this and let you know I changed from 8.0 to 7.4 and all seems to be well with the world. Many thanks for your assistance.