Thank you for your effort. I have a small suggestion: please follow the naming convention when you name the columns. In filter data, you use names for Table, View, Slices, and Dashboard. This can be a bit confusing in terms of understanding.
Hei Joe, I like your tutorial,its really help me to learn Appsheet, but there no tutorial about Maps Aplication like map tracker, or similar app like that ..Etc grab location..please make tutorial👍
Great explanation @Joe Can we add a detailed view on top of the collection in the dashboard that’s only shown if a certain value exists in the data table? For example a warning.
To save anyone in future the trouble of dealing with customizing this expression and encountered issues: Yes, the reference, as pointed out by someone's comment, is reveresed. Given three tables: Filter (containing filter fields), Dataset (unfiltered results) and Collection (filtered results by using slice) -> you should set the row filter condition of Collection table to: ISNOTBLANK( ANY( SELECT(Dataset[ID], AND(IF([_ThisRow].[DATE]=INDEX(Filter[Date],1), Condition 2..., Condition 3.... and so on))))
Hi! Great video, this is exactly what I needed to my simple app about quality issues. Is there any option to make dates valid and the rest of fitler's items make optional? I mean I choose start and finish data which should be required but I don't have to choose Chashier ID and Paymanet Type. Thank you in advance for your response ;)
I managed to make it work. But I dont really understand why, if you are filtering on the collection table the select is referenced to the filter[id]. It makes more sense to be references to the collection[id] so it can bring all the registers from that table. Anyway it works, thanks.
This is a great video! This is perfect for my monthly tally sheets. Question: How was the banner content added? I created a virtual column, set the data type to 'show' and set the formula to " ". How do I add the image? I also noticed the cashier dropdown shows the cashier id. Is there a way to display the cashier's name instead?
GOOD JOB!! this is perfect! this is also what am looking for awhile now. THANK YOU SOO MUCH! Will it be possible to add TOTAL for the Amount? and maybe before showing the data will be filtered is to show first all the data then you can then choose to filter it? KUDOS!!
Would you be so kind to share a screenshot of your collection table, 'to know what type each column is and to better understand the exercise? I would really appreciate it, thank you
Hello thanks for the tutorial, it helped me alot. I follow all of the instructions, it works fine in browser, but in android version, when im export the csv it didn't show anything, is there any possible way to fix this ? Thank you
nice! question how to export only specific column as showed on my filtered view. i tried to follow and export the file but it includes all the columns in my database
HI Mr. Joe All are working great but CSV action icon not appearing, i have already try " view Prominence Display as primary Display prominently Display inline " ?
Hi can I confirm something? Seems like the filter is working by live-editing the cells. What happens if there are multiple searches by multiple users that are using the filter function?
Hy Joe, I have row that hold 2 value. (e.g. Column "worker" with row value name of the worker (John, Smith). it seem with this formula it only capture row with one value only. is there any work around to able capture one name in the the row?
Would like to check how can I select with multiple payment type? I tried to change the payment type to Enumlist and select multiple payment type but it showed "THIS ENTRY IS INVALID".
IS this expression right Isnotblank(Any(Select(Filter[ID],And([_Thisrow].[DATE]>=[START DATE],[_Thisrow].[Date]=[END DATE],[_Thisrow].[VISIT TYPE]=FILTER[VISIT TYPE],[_Thisrow].[FEE MODE]=FILTER[FEES MODE])))) or should i have to remove the worksheet name "FILTER" in the expression My first worksheet name is MASTER and second one is FILTER, the column names are same in bothe the sheets it throws out this error Cannot compare List with Text in ([_Thisrow].[VISIT TYPE] = [VISIT TYPE])
Hey man, thx for the video. I got a question: on 18:09 on your filtered data you have there 3 entries on Jan 1 and 2 entries on Jan 2. So they are shown one by one right? Let's assume that they are quantities, you made three sales and entered them separately, like this: 2 pcs. then 3 pcs. and then 4 pcs. So on that day you have 9 pcs of sales in total. How can you display all entries that are on the same date as one row? Like when you filter that date, instead of displaying 2+3+4, I want it to show me just the total 9... Hope I could explain what I mean... :)
When I export from crome browser CSV file is export but when i am exporting from mobile Android app file not export but massage come file export successfully
Hi Joe How can I use (extract) date from my DateTime Column (Date & Time) to use in the expression for the filter. [_Thisrow].[Date & Time]=[Start Date],
@@JoeTayactac thanks! I wrapped it in Date([Date & Time]) and it works now. But the start and end date expression isn't filtering rows between the different dates. Edit: Fixed! I added greater and less than operators in the date :)
I had this problem and did had to append the tables in google sheets before and use this table in the app. You can use the ={query (table 1 ); query(table 2) } in G sheets
Hello there, How can we list the total quantities and total amounts according to the selections? For example, I want to make a filter that returns the totals when selected according to the information given below. When no seller is selected, I want to list all sellers and see how many items they have sold and their sales totals: Start Date : 01.09.2022 End Date : 04.11.2022 Seller ID : Seller01 (Seller02, Seller03, Seller04, SellerXX...) Payment : Cash Product : Mobile Phone Brand : Iphone 12 Feature : 64 Gb Sales Quantity : ? Total Sales : ?
@@JoeTayactac In this case, only 1 line of information is received. When no selection is made in the vendor section and the product section, how can we list all vendors as UNIQUE and see how many of which vendors have sold between the start and end dates of the vendors, and their total amounts in a table?
@@JoeTayactac In short, between two dates, for example in September, I would like to see how many of each or every seller's product sold, and the sales totals in a tabular form.
You need to create a parent and child relationship. Seller is the parent table and Sales are the child record. Then you can add in Seller table the ref_rows("Sales","Ref Column")and add it to the inline view. Then create a filter table
THANKS FOR THIS...been having sleepless night over this..
This video has been a huge help in completely my project. Thank you and keep up the good work.
Thank you sir
You complete my project in a second in this video❤
Thanks bro, this is the easiest one
Thank you for your effort. I have a small suggestion: please follow the naming convention when you name the columns. In filter data, you use names for Table, View, Slices, and Dashboard. This can be a bit confusing in terms of understanding.
Hei Joe, I like your tutorial,its really help me to learn Appsheet, but there no tutorial about Maps Aplication like map tracker, or similar app like that ..Etc grab location..please make tutorial👍
Hi, morning, amazing content
Great explanation @Joe
Can we add a detailed view on top of the collection in the dashboard that’s only shown if a certain value exists in the data table? For example a warning.
Hi, Im not sure if I understand what you are trying to explain. Please explain more
Excellent teaching
Hello thanks for the video, but I need a help, is possible to show after the filter the sum?
To save anyone in future the trouble of dealing with customizing this expression and encountered issues:
Yes, the reference, as pointed out by someone's comment, is reveresed.
Given three tables: Filter (containing filter fields), Dataset (unfiltered results) and Collection (filtered results by using slice) -> you should set the row filter condition of Collection table to:
ISNOTBLANK(
ANY(
SELECT(Dataset[ID],
AND(IF([_ThisRow].[DATE]=INDEX(Filter[Date],1),
Condition 2...,
Condition 3.... and so on))))
Hi! Great video, this is exactly what I needed to my simple app about quality issues. Is there any option to make dates valid and the rest of fitler's items make optional? I mean I choose start and finish data which should be required but I don't have to choose Chashier ID and Paymanet Type. Thank you in advance for your response ;)
I managed to make it work. But I dont really understand why, if you are filtering on the collection table the select is referenced to the filter[id]. It makes more sense to be references to the collection[id] so it can bring all the registers from that table. Anyway it works, thanks.
Very detailed tutorial. Kudos sayo kabayan. More tutorials and subscriber to go.
There is a problem with de page, if you duplicate the window with the filters, you will have the same filters with data. Help please!
It helped me, many thank.
Thanks ❤
i got a question: could you show for us the key column for collection table please ?
thanks for this very helpfullll.
This is a great video! This is perfect for my monthly tally sheets. Question: How was the banner content added? I created a virtual column, set the data type to 'show' and set the formula to " ". How do I add the image?
I also noticed the cashier dropdown shows the cashier id. Is there a way to display the cashier's name instead?
Go to the cashier table and set the name as label. That should work
Thank you for this. How would I change the formula in the slice to summarise according to lets say a product.
Worked perfectly!
Please any help me
What is csv download location in mobile
GOOD JOB!! this is perfect! this is also what am looking for awhile now. THANK YOU SOO MUCH!
Will it be possible to add TOTAL for the Amount? and maybe before showing the data will be filtered is to show first all the data then you can then choose to filter it?
KUDOS!!
Thank you so much
Hi Dear, very nice video appreciate if I want to ck total amt of sales with flitter is it possible can you plz help..❤
Would you be so kind to share a screenshot of your collection table, 'to know what type each column is and to better understand the exercise? I would really appreciate it, thank you
Hello thanks for the tutorial, it helped me alot.
I follow all of the instructions, it works fine in browser, but in android version, when im export the csv it didn't show anything, is there any possible way to fix this ?
Thank you
Csv will not work in mobile app
nice! question how to export only specific column as showed on my filtered view. i tried to follow and export the file but it includes all the columns in my database
Use slice and select/include only the columns you need
after downloading the csv file, why are there empty columns in the result, not the same as the filter results
Hello, excellent video, one question how could I add a counter for example the amount of payments. Thanks
Hi,
Sorry I did not understand itm do you mean sum or total payments?
Great video! Thanks.
Could you explain the Banner column setting of the Filter table?
Its a show type column and image type with image url enclosed with "url"
Great video, thanks! Could the "Clear Filter" button be placed in a little more UX friendly position?
You can change it as primary action
HI Mr. Joe All are working great but CSV action icon not appearing, i have already try " view Prominence
Display as primary
Display prominently
Display inline
"
?
Hi,
Please check option display action in dashboard
Thanks
Hi joe, when i use security filter for sheet data, it show perfect value in filter board, but when i export csv, it's blank , 😢, how can i fix it
great 👍
Hi can I confirm something?
Seems like the filter is working by live-editing the cells.
What happens if there are multiple searches by multiple users that are using the filter function?
Hi, you can follow this video to solve that issue
th-cam.com/video/5lQ3roJG0Hw/w-d-xo.html
Hi, thanks for your video. It helped me a lot. But I need it to be exported to PDF. how can i do it?
Will make a video soon
@@JoeTayactac I'll wait for it, thanks.
thank you indeed. I followed all the step, but I the CSV icon does not appear to export the filtered data. Please help me.
You have to expand the view in Dashboard and Display Main Promininse
Hy Joe, I have row that hold 2 value. (e.g. Column "worker" with row value name of the worker (John, Smith). it seem with this formula it only capture row with one value only. is there any work around to able capture one name in the the row?
Hi you can do some tweaks in the formula. If you have 2 rows as reference you can always use And expression .
Obrigado, me ajudou muito.
@Joe But problem with the above is that only one user can access dashboard at a time? how to solve that?
Checkout the another video th-cam.com/video/5lQ3roJG0Hw/w-d-xo.htmlsi=t86SqSMtYI8-YHtJ
@@JoeTayactac solved! Problem solved 😊😊
@@JoeTayactac in this one it is only for online users. Is there any alternative for offline users??
@@JoeTayactac I am looking non-user settings alternative.
thanks mate
Would like to check how can I select with multiple payment type? I tried to change the payment type to Enumlist and select multiple payment type but it showed "THIS ENTRY IS INVALID".
Hi,
You have to change the expression. I will have a video for that
You mean like this? th-cam.com/video/S8B4cVIiQV0/w-d-xo.html
I've watched your video 5 times, but the end result is not the same. The dashboard is different. I followed all your steps, can you help me please?
IS this expression right
Isnotblank(Any(Select(Filter[ID],And([_Thisrow].[DATE]>=[START DATE],[_Thisrow].[Date]=[END DATE],[_Thisrow].[VISIT TYPE]=FILTER[VISIT TYPE],[_Thisrow].[FEE MODE]=FILTER[FEES MODE]))))
or should i have to remove the worksheet name "FILTER" in the expression
My first worksheet name is MASTER and second one is FILTER, the column names are same in bothe the sheets
it throws out this error Cannot compare List with Text in ([_Thisrow].[VISIT TYPE] = [VISIT TYPE])
[Fee Mode]=Filter[Mode] is wrong you cannot compare this two.
@@JoeTayactac Found out the mistake its fee mode in worksheet and feeS mode in another. rectified it but still returns no data
Hey man, thx for the video. I got a question: on 18:09 on your filtered data you have there 3 entries on Jan 1 and 2 entries on Jan 2. So they are shown one by one right? Let's assume that they are quantities, you made three sales and entered them separately, like this: 2 pcs. then 3 pcs. and then 4 pcs. So on that day you have 9 pcs of sales in total. How can you display all entries that are on the same date as one row? Like when you filter that date, instead of displaying 2+3+4, I want it to show me just the total 9... Hope I could explain what I mean... :)
You can group the results by column . Let say in your case [quantity] then summarize by total quantity. You can do that in UX when creating a view
But what if you wanted to export it in CSV grouped as well?
This tutorial is VERY GOOD 👍 but not 🚫 complete bcoz this here won't work for multiple users searching 🔍😊
Joe, can we display both payment types when nothing is selected?
You may try to replace the filter formula instead of And try using Or
@@JoeTayactac thanks for the suggestion. I just don't know how to work this out without adding another enum
it is work very well but when i try in mobile export data does not work. it is only showing . but download in computer not in mobile pls help me
Csv is only for desktop user
very nice
how ew can put total at the end of after filtering data
You can create a virtual coloumn in Filter and use Sum(Select(Collection[Amount],And([ ],[ ],[ ])))
@@JoeTayactac please provived with example
Any possible to export the view to WhatsApp?
When I export from crome browser CSV file is export but when i am exporting from mobile Android app file not export but massage come file export successfully
Hi csv is for browser/desktop only
@@JoeTayactac then what is the option for export from mobile app
Hi Joe
How can I use (extract) date from my DateTime Column (Date & Time) to use in the expression for the filter.
[_Thisrow].[Date & Time]=[Start Date],
You have to change start date to date and time too
@@JoeTayactac thanks!
I wrapped it in Date([Date & Time]) and it works now.
But the start and end date expression isn't filtering rows between the different dates.
Edit: Fixed! I added greater and less than operators in the date :)
Hi
Can we download pdf file instead of CSV file
Thanks in advance
Do you know how to duplicate a parent record along with its child record?
How you trigger this ?
I have done it step by step, but my Dashboard gives a Blank Filtered data
I have a new video for multiple selection maybe will help you th-cam.com/video/uDvbgDeFsYE/w-d-xo.html
How to filter data from 2 different tables?
Hi.
You can filter more tables as you like
As long as the reference filter is same. With same procedure
I had this problem and did had to append the tables in google sheets before and use this table in the app. You can use the ={query (table 1 ); query(table 2) } in G sheets
bro you have written wrong formula in description
hi
Hello there,
How can we list the total quantities and total amounts according to the selections?
For example, I want to make a filter that returns the totals when selected according to the information given below. When no seller is selected, I want to list all sellers and see how many items they have sold and their sales totals:
Start Date : 01.09.2022
End Date : 04.11.2022
Seller ID : Seller01 (Seller02, Seller03, Seller04, SellerXX...)
Payment : Cash
Product : Mobile Phone
Brand : Iphone 12
Feature : 64 Gb
Sales Quantity : ?
Total Sales : ?
You can add 2 virtual coloumn in Filter and use Sum(Select(Table[Sales],And([]=[]=[]])))
Sum(Select(Table[Quantity],And([]=[]=[])))
@@JoeTayactac In this case, only 1 line of information is received.
When no selection is made in the vendor section and the product section, how can we list all vendors as UNIQUE and see how many of which vendors have sold between the start and end dates of the vendors, and their total amounts in a table?
@@JoeTayactac In short, between two dates, for example in September, I would like to see how many of each or every seller's product sold, and the sales totals in a tabular form.
You need to create a parent and child relationship. Seller is the parent table and Sales are the child record. Then you can add in Seller table the ref_rows("Sales","Ref Column")and add it to the inline view. Then create a filter table
@@JoeTayactac We would be very pleased if you make a video about it in your next videos.