Hello, I followed your video step by step but I have a problem. On your video 15'37'', you show how to change the source and select rel_revenue. I tried but the source for me is not available and I cannot select it. Any idea what is the problem ? Thanks
I've been using your video as a step by step guide to building my current app. When I go to source my relation tab to my "revenue," the relations option is not available as a selection. Is there something I've done wrong? How can I go about fixing this issue?
Hello, thank you so much for the video! Your explanations are very clear and engaging ! i I have a question about the worktable table. If we'd want to introduce another choice. for example a category for the revenu and we want to filter on the category instead of a timeframe. My question is, in the worktable, do I add another row for each choice ? or do I add a category column in the same row that will be populate by the user choice in the tab. the second option seems to work, but I wonder what is the best way to build if we are looking to have different choice for different users.
I would say have a working table that’s just meant to be the source of the screen. The different choices for your categories can exist in any other table. In that same table, you can define, which category should be visible to which user. Then you can filter the choice component. The choice component will ultimately write to a user specific column in the working table.
Repeat the process with a second choice component. Take a look at my video: Filter an inline list using a choice component th-cam.com/video/NOYFsVUWQXw/w-d-xo.html
@@RobertPetittoWA I'm dying! do you mean making a second row in the "Work table"? to be able to add a second area of choice? I'm trying to label selected categories prior the date, so you can see only the categories selected and then the range of dates. No sucess yet :(
Thanks for good lessons, I would like to know you can send data to different columns in the same row with an row id, id in A1, VALUE1 in B1 AND VALUE2, Then you update the data row wise in different instance i.e. value1 in b2 today and tomorrow value 2 in C2. in Google sheet. Thanks in advance.
What you see in the data editor after creating a relation is just a visual representation of the connection. What you’ll see is the first column in the destination table. If you need the name, you’ll need to add a look up column.
Hello,
I followed your video step by step but I have a problem. On your video 15'37'', you show how to change the source and select rel_revenue.
I tried but the source for me is not available and I cannot select it.
Any idea what is the problem ?
Thanks
Did you ensure that you checked the box to match multiple within the rel_revenue column?
@@RobertPetittoWA yes it is checked
Not sure then…would need to see it
Thank you! Is this still the most up to date way to filter timeframes?
There’s quite a few ways to filter timeframes. This happens to be my favorite way.
Great video. Can't wait for part 2 as this is what I need.
Thanks for the nudge. I’ll produce a followup soon!
I've been using your video as a step by step guide to building my current app. When I go to source my relation tab to my "revenue," the relations option is not available as a selection. Is there something I've done wrong? How can I go about fixing this issue?
What time stamp in the video are you referring to?
Thank you for this complete and precise tutorial! I can't wait to see part 2
Thanks for the reminder!!!
Thank you, this tutorial is so helpful! Is there a formula for the current quarter?
Year(date)*100+floor(month(date)/4)+1
This might work.
@@RobertPetittoWA This works great!! Thank you for taking the time to reply.
Thank u Robert! This is a very useful and practical !
My pleasure
Hello, thank you so much for the video! Your explanations are very clear and engaging !
i I have a question about the worktable table. If we'd want to introduce another choice. for example a category for the revenu and we want to filter on the category instead of a timeframe.
My question is, in the worktable, do I add another row for each choice ? or do I add a category column in the same row that will be populate by the user choice in the tab.
the second option seems to work, but I wonder what is the best way to build if we are looking to have different choice for different users.
I would say have a working table that’s just meant to be the source of the screen. The different choices for your categories can exist in any other table. In that same table, you can define, which category should be visible to which user. Then you can filter the choice component. The choice component will ultimately write to a user specific column in the working table.
💡💡💡💡 Thanks a million! Definitely what I needed to see right now!
Perfect!
Great video! how would you add a secondary filter on top of this filter you have created?
Repeat the process with a second choice component. Take a look at my video: Filter an inline list using a choice component
th-cam.com/video/NOYFsVUWQXw/w-d-xo.html
@@RobertPetittoWA I'm dying! do you mean making a second row in the "Work table"? to be able to add a second area of choice? I'm trying to label selected categories prior the date, so you can see only the categories selected and then the range of dates. No sucess yet :(
Fantastic video! How different would this be with Airtable tables?
No difference at all since all the calculations are done Glide side.
Thanks for good lessons, I would like to know you can send data to different columns in the same row with an row id, id in A1, VALUE1 in B1 AND VALUE2, Then you update the data row wise in different instance i.e. value1 in b2 today and tomorrow value 2 in C2. in Google sheet. Thanks in advance.
you are just incredible, thanks for the helpful video)
Happy to help!
Another great lesson. Thanks.
My pleasure!
If you added charts to the detail screen, would the charts also dynamically change based on the timeframe filter?
As long as you’re using the same filters on the chart, yes!
Hi, how do you custom format the Inline List items?
Depends what you’re trying to format.
“Not terribly complicated”. Well now that you lead us through it, no. But to create it, that was brilliant.
Glad you approve 👍
Thanks, another great video 🏆🏆
Much appreciated!
hi may i know why when i set the relation, the name doesnt come out
What you see in the data editor after creating a relation is just a visual representation of the connection. What you’ll see is the first column in the destination table. If you need the name, you’ll need to add a look up column.
Is part two out yet? Can't find it.
Still working on it!
A técnica de converter as datas é muito útil.
Obrigada
This is great!!! 😮
Thank you!
How to present it with chart not with inline list?
Just use the same filters in the chart > options
You are f* amazing :) Thanks a lot for sharing this tip
You’re absolutely welcome!
love you!!!
Aw thank you! ☺️
Thanks you!!
You're welcome!
Ah, this is cool!
Glad you like it!
How to get sum of quantity within a two date which includes that two date
By “two date” do you mean a date and the day after? Two selected dates?
Waiting for last day, last 7 day video anyone now how to do it ?
Have you seen part 2 yet?