About marsbar

marsbar · 09-11-2023

Hi AllI have created a group of apps that link together to make one overall app, using a main dashboard. Firstly am I right in thinking that these cant be merged into one app - if not I'll publish the main dashboard.I am wanting to:Publish a generic ...

marsbar · 02-08-2023

Hi,Im getting closer to being at the final publishing stage of an app that we have designed for our business. This app is basically a collection of apps that are used as sections to form a main dashboard... these are fed by various spreadsheets store...

marsbar · 02-06-2023

Hi all - another day, another question!!I have a dashboard showing various charts (Histograms) - this results in small overviews that I have to click on to enlarge to see the actual data - or rollover the column precisely to see the totals...What I a...

marsbar · 01-24-2023

Hi All - Please help!!I have a table made up of three TYPE Columns (Type A/Type B/Type C) - there are also columns for costs associated with these (Type A £/Type B £/Type C £). I also have a Total £ column combining the other £ columns.Within each ty...

marsbar · 01-09-2023

Hi AllAnother day - another question!!I have a table - "Data" which I want to be able to filter by specific date ranges, I have the following date filter formulas on a slice which works brilliantly (Thanks to this forum!):IN( [Payment Date Column], S...

marsbar · 02-06-2023

Thanks again for this - Ive looked at the links and googled but I just can't get my head around it... So Ive created the initial link for a chart https://quickchart.io/chart/render/zm-9d8dcc63-dad6-4e73-9e1a-87db0dd6e722How do I then get that to show...

marsbar · 02-06-2023

Thanks for this - so just to humour me - is this a visualisation of the live data from the app?

marsbar · 01-24-2023

Hi Sorry- does this mean that I could create a slice for:only if [Type A]=Sub Cat 1, [Type A]=Sub Cat 2, [Type A]=Sub Cat 3another slice for only if [Type B]=Sub Cat 4, [Type B]=Sub Cat 5 [Type B]=Sub Cat 6another slice for [Type C]=Sub Cat 7, [Type ...

marsbar · 01-10-2023

thanks for this! I think the issue was the IN statement maybe preventing the extra filter of job type from working. Thanks for this!!

marsbar · 01-10-2023

You are a genius! thanks so much for this... I really need to get my head around these expressions. I find the appsheet documentation a bit baffling when you get past the basics. Thanks so much for this mate. I may be bending your ear again soon (sor...

My Stats

marsbar's Bio

Badges marsbar Earned

Recent Activity

Distributing, cloning and licencing apps

App distribution to third parties

Snapshot of data totals automated each week

Totalling Different Types by Sub Category in one slice?

Additional Filtering

Re: Snapshot of data totals automated each week

Re: Snapshot of data totals automated each week

Re: Totalling Different Types by Sub Category in one slice?

Re: Additional Filtering

Re: Additional Filtering