Please suggest expression to filter parent record based on products in child record, from product column in filter dashboard. Products are added as line items in parent table.
I need help. Lol. I have a spreadsheet that has lat and long (ex: 54.864,-1345664). I have a table slice and a map slice. The spreadsheet houses 100 records with latitude and longitude. For some reason, I can't seem to get the lat/long points to show up on the map view. If I do full address it will though. Am I doing something wrong? I've been biting my nails and am lost. Please, if you could help, I would appreciate it
Great question Josh! Here is an article we wrote about XY Map Views: appsheettraining.com/article/appsheet-tips-tricks-xy-map-views We also have Tech Talks available for you to meet with us to discuss your AppSheet App. You can sign up here: calendly.com/austin-qrew/15min Talk soon, Austin from AppSheet Training
Thanks for this, I managed to get it working but I’m having trouble with the expression for an ennumlist of refs. I want to be able to select multiple persons and display their data but I can’t seem to form the IN() expression.
@@MuhammadSaloojee hi yup managed to get it working. [Issue Type] is the ennumlist column here IF(ISBLANK(ANY(Dashboard Filter[Issue Type Filter])), TRUE, [Issue Type] = ANY(Dashboard Filter[Issue Type Filter])),
Thanks, this was very helpful! Whenenver I click on an account in the filtered accounts view, the filters disappear. When I deselect the account in the filtered accounts view the filters reappear. Any idea why this might be happening?
I got some help from the AppSheet community and figured it out. My filter columns were in a User table that had references to the other tables. Once I moved my filter columns to a separate table the filters stopped disappearing.
dear trainer, is there a way to code in "bookmark" in a certain row or column in the excel sheet, whereby users can see. a "bookmark" button to press on the app. Much appreciated Sir. tqvm
-Add a column called [Bookmarked] -Add a action that changes [Bookmarked] to = [Bookmarked],USEREMAIL() -Add a Slice of rows where USEREMAIL() is IN() [Bookmarked]
I set everything up twice over, exactly how you did in your video and my filter detail won't show up in my dashboard. I add it to it and the detail box just shows "No Results". I have re-watched this video over and over and I can't figure out what's wrong/different.
Thank you! How can we do multi selects to bring up data from a referenced table as enumlist.. Use case: I have a tasks table, and a users table.. Tasks can be assigned to multiple users.. I want to select multiple users in the filter and then show all tasks if they're one of the users assigned to those tasks... For example, If I select Adam, Noah, Moses,... Then if there's 1 task with Adam, another with Adam and Noah, and another with Adam, Noah and Moses,... All 3 of these tasks should show even though the users assigned vary.
Great video. Thank. Didn't know this was possible. Will definitely be building this into my app. Any chance anyone knows which extension he uses at around 30 minutes in to help him reference the data?
Having a Users table certainly comes in handy in this case. If an app already had a need for a users table like this, would there be any unique purpose to use the usersettings() feature?
We prefer using a User table because if a change is made in the User Setting the change does not come into effect until the app is resynced. I'm sure there is an abstract use-case where you'd want that but 99% of the time its worth building out a user's table.
@@AppSheetTraining Thank you for this reply. Then I hope Appsheet 'bakes in' users tables tied to logins similar to the usersettings, otherwise yeah, I'll be making user tables over usersettings every time. Thanks for confirming my suspicions.
Thanks for the informative videos! As a service company, I wonder if it's possible to create a dashboard for my customers where they can see the dates of the next visits, possibly reschedule them, check their invoces or change their phone numbers etc without me having to pay the subscription fee after each of them. Maybe any workaround with API?
Thanks... This was a great session... I didn't know it was possible to filter dashboards like that... Very useful... I'll be building that into my app... Cheers... :)
OK, so I've implemented this in my XY Map-based app now and I have to say it's (by far) my new favourite part of my app... Very versatile... So easy to view/visualise all kinds of information... Absolutely fantastic... Best thing since sliced bread... Thanks AST, Clark & CJ... :)
dear appsheet, is there a reason why is it on my UX TAB - VIEWS , when the view type selected is "card" - on the right view of the preview screen showing the app , it indicates an "exclamation mark" on the left part (just beside the name) . Much appreciated Sir TQVM for advice in advance please.
Hello we are a Third Party AppSheet Educator not related to the AppSheet Team, but seems like the issue you're experiencing is usually caused when their is reference that is reffing a deleted column. Make sure the Key for all refs in the row showing the error is still in the database.
Hi Ive applied this to my app succesfully, however when it comes to multiple users it doesnt work. It only works for the first user on the user list. for some reason the row filter condition does not edit the other user emails. Ive tried this by previewing the app as the other emails on the lists. I have followed everything he has done meticulously.
Check the slice that filters the userstable with useremail(). Since this slice is the one used for the Detail View, if you are not filtering the slice, it will show the first row as DV
Yeah that can be done using the 'Valid If' field when you click the edit pencil for that column. Just set up a filter statement in the valid if that pass through the rows that you want to show up. Most commonly a user would select a company in one and then the valid if would show all WorkOrders that Company=the company select
This is awesome! Had to rewind and rewatch a dozen times but finally got it to work. I'm using it with a Map view and am finding that it takes quite a bit of time to sync/filter every time you make a change. Not sure how his example is instantaneous.
@@AppSheetTraining Thanks for the tip. Assume you are talking about the Options>Map View> Pin Limit? If so, increased to 200 and no improvement. Any other suggestions. This is a really great feature for dashboards. Like...should be fully integrated... great!
The cluster size setting is in the UX menu >> your map view settings. Sometimes, expressions with lots of select, lookups, and contains expressions can slow the searching down.
Please suggest expression to filter parent record based on products in child record, from product column in filter dashboard. Products are added as line items in parent table.
Hi I'm Ariful Islam leeton im software engineer and software development and website
I need help. Lol. I have a spreadsheet that has lat and long (ex: 54.864,-1345664). I have a table slice and a map slice. The spreadsheet houses 100 records with latitude and longitude. For some reason, I can't seem to get the lat/long points to show up on the map view. If I do full address it will though. Am I doing something wrong? I've been biting my nails and am lost. Please, if you could help, I would appreciate it
Great question Josh! Here is an article we wrote about XY Map Views: appsheettraining.com/article/appsheet-tips-tricks-xy-map-views
We also have Tech Talks available for you to meet with us to discuss your AppSheet App. You can sign up here: calendly.com/austin-qrew/15min
Talk soon,
Austin from AppSheet Training
How did you add the Last Week or Next Week button filters?
Thanks for this, I managed to get it working but I’m having trouble with the expression for an ennumlist of refs. I want to be able to select multiple persons and display their data but I can’t seem to form the IN() expression.
Hi, did you get this right? I'm trying to do the same.
@@MuhammadSaloojee hi yup managed to get it working. [Issue Type] is the ennumlist column here
IF(ISBLANK(ANY(Dashboard Filter[Issue Type Filter])), TRUE,
[Issue Type] = ANY(Dashboard Filter[Issue Type Filter])),
Thanks, this was very helpful! Whenenver I click on an account in the filtered accounts view, the filters disappear. When I deselect the account in the filtered accounts view the filters reappear. Any idea why this might be happening?
I got some help from the AppSheet community and figured it out. My filter columns were in a User table that had references to the other tables. Once I moved my filter columns to a separate table the filters stopped disappearing.
dear trainer, is there a way to code in "bookmark" in a certain row or column in the excel sheet, whereby users can see. a "bookmark" button to press on the app. Much appreciated Sir. tqvm
-Add a column called [Bookmarked]
-Add a action that changes [Bookmarked] to = [Bookmarked],USEREMAIL()
-Add a Slice of rows where USEREMAIL() is IN() [Bookmarked]
Okay this is complicating . Is there a way to reach by email or call , or any consultation fee I’m very happy to discuss please Sir .
I think google needs to add a lot of sample dashboards backed by mock data for people to just get started.
That’s a really good idea!
I set everything up twice over, exactly how you did in your video and my filter detail won't show up in my dashboard. I add it to it and the detail box just shows "No Results". I have re-watched this video over and over and I can't figure out what's wrong/different.
Maybe you're unaware but Google Sheets offers the ability to import an Excel spreadsheet without the need to copy and paste.
Thank you! How can we do multi selects to bring up data from a referenced table as enumlist.. Use case: I have a tasks table, and a users table.. Tasks can be assigned to multiple users.. I want to select multiple users in the filter and then show all tasks if they're one of the users assigned to those tasks...
For example, If I select Adam, Noah, Moses,... Then if there's 1 task with Adam, another with Adam and Noah, and another with Adam, Noah and Moses,... All 3 of these tasks should show even though the users assigned vary.
Great video. Thank. Didn't know this was possible. Will definitely be building this into my app.
Any chance anyone knows which extension he uses at around 30 minutes in to help him reference the data?
Its one we've developed named QREW Tools on the Chrome Store for free.
Search it on our channel if you want to know more about it!
@@AppSheetTraining got it. Thanks
Having a Users table certainly comes in handy in this case. If an app already had a need for a users table like this, would there be any unique purpose to use the usersettings() feature?
We prefer using a User table because if a change is made in the User Setting the change does not come into effect until the app is resynced. I'm sure there is an abstract use-case where you'd want that but 99% of the time its worth building out a user's table.
@@AppSheetTraining Thank you for this reply. Then I hope Appsheet 'bakes in' users tables tied to logins similar to the usersettings, otherwise yeah, I'll be making user tables over usersettings every time. Thanks for confirming my suspicions.
Hi,
Maybe I’m missing something what did you use the applauncher table for?
Hi. How come i kept getting error in Row Filter Condition Expressions if I include AND on top?
Thanks for the informative videos!
As a service company, I wonder if it's possible to create a dashboard for my customers where they can see the dates of the next visits, possibly reschedule them, check their invoces or change their phone numbers etc without me having to pay the subscription fee after each of them. Maybe any workaround with API?
How work automec serial number for rows in appsheet ?
Thanks... This was a great session... I didn't know it was possible to filter dashboards like that... Very useful... I'll be building that into my app... Cheers... :)
OK, so I've implemented this in my XY Map-based app now and I have to say it's (by far) my new favourite part of my app... Very versatile... So easy to view/visualise all kinds of information... Absolutely fantastic... Best thing since sliced bread... Thanks AST, Clark & CJ... :)
So glad it’s working for you! Dynamic filtering on XY maps is a powerful feature. It opens lots of doors
dear appsheet, is there a reason why is it on my UX TAB - VIEWS , when the view type selected is "card" - on the right view of the preview screen showing the app , it indicates an "exclamation mark" on the left part (just beside the name) . Much appreciated Sir TQVM for advice in advance please.
Hello we are a Third Party AppSheet Educator not related to the AppSheet Team, but seems like the issue you're experiencing is usually caused when their is reference that is reffing a deleted column. Make sure the Key for all refs in the row showing the error is still in the database.
Hi Ive applied this to my app succesfully, however when it comes to multiple users it doesnt work. It only works for the first user on the user list. for some reason the row filter condition does not edit the other user emails. Ive tried this by previewing the app as the other emails on the lists. I have followed everything he has done meticulously.
Check the slice that filters the userstable with useremail(). Since this slice is the one used for the Detail View, if you are not filtering the slice, it will show the first row as DV
HOW TO CREATE A DATE IN THE FORMAT "21/01/2021 S / D 25/01/2021" IN 1 DATE COLUMN IN THE APP SHEET?
You can display a date in any date format using the TEXT() formula. You can learn more about it here appsheettraining.com/expressions/text-text
very useful! thanks a lot
Is there a way to make the dropdowns dependent and allows multiple selections in a single dropdown?
Yeah that can be done using the 'Valid If' field when you click the edit pencil for that column. Just set up a filter statement in the valid if that pass through the rows that you want to show up. Most commonly a user would select a company in one and then the valid if would show all WorkOrders that Company=the company select
ty so much
This is awesome! Had to rewind and rewatch a dozen times but finally got it to work. I'm using it with a Map view and am finding that it takes quite a bit of time to sync/filter every time you make a change. Not sure how his example is instantaneous.
If you increase the map cluster size, it may improve performance.
@@AppSheetTraining Thanks for the tip. Assume you are talking about the Options>Map View> Pin Limit? If so, increased to 200 and no improvement. Any other suggestions. This is a really great feature for dashboards. Like...should be fully integrated... great!
The cluster size setting is in the UX menu >> your map view settings.
Sometimes, expressions with lots of select, lookups, and contains expressions can slow the searching down.
Very good training
Thank you! Are there any topics you’d would like us to cover?
@@AppSheetTraining Interactive Data
Can you share the expression you type?
Do you mean data that you can search through and filter?
We will be releasing a series that covers every AppSheet Expression early next year