# Interactive App **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [July 10, 2022, 9:02am UTC](https://community.thunkable.com/t/interactive-app/1958813 "2022-07-10T09:02:01Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 9:02am UTC](https://community.thunkable.com/t/interactive-app/1958813/1 "2022-07-10T09:02:01Z")
We have 10 taxi with us were driver does the cash trip and keeps cash with him… The another Employee who collects the cash is not having information from which driver how much cash to be collected… We can save Date wise & driver wise cash trip details in google sheet. when collector visits in 1 or 2 or 3 days, he should able to see driver wise how many trips and how much cash to be collected… Then he need to check those entries and submit so that we will come to know how much cash is collected by the collector. Those collected entries should not reflect later on his app. Order id will be the unique number for each trip > **[Test-for cash collection](https://docs.google.com/spreadsheets/d/10zvQtY2FVSbFeuSIHGMxqJ5JOh45xIskNGk7KXw0Eww/edit?usp=sharing)** > > Sheet1 > > Order ID,Dispatched On,Vehicle ID,value,Total Fare > 22004646,01-Jun-2022 00:32,L16563,224 - Saddam Hussain - +971565337703,191.1 > 22004463,01-Jun-2022 05:35,L28162,16 - Zafer Khan - +971565251357,498.75 > 22004640,01-Jun-2022 06:16,L28793,23 -... [Test-for cash collection.csv](https://community.thunkable.com/uploads/short-url/nQNBciNur6GYOe9sYiGtas6kOSF.csv) (89.0 KB) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 9:50am UTC](https://community.thunkable.com/t/interactive-app/1958813/2 "2022-07-10T09:50:59Z")
Welcome to Thunkable You explained your situation but have not explained where you got **stuck** in your app. Can you provide more information on your problem in the app and show the screenshot of your blocks? ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 10:10am UTC](https://community.thunkable.com/t/interactive-app/1958813/3 "2022-07-10T10:10:04Z")
Actually I am a new to this, hence not able to understand how to build it & how to use blocks Also wanted to know is the solution to our problem is possible in Thunkable app. can we make the app as per our problem. If yes can someone assist me in building ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 10:50am UTC](https://community.thunkable.com/t/interactive-app/1958813/4 "2022-07-10T10:50:20Z")
> [@fareedxz](#): > > is the solution to our problem is possible in Thunkable app Yes it is very possible. > [@fareedxz](#): > > make the app as per our problem. Yes you can. > [@fareedxz](#): > > can someone assist me in building Assisting or building the whole project? ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 11:02am UTC](https://community.thunkable.com/t/interactive-app/1958813/5 "2022-07-10T11:02:16Z")
please assist what would be the charges if you build ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 11:20am UTC](https://community.thunkable.com/t/interactive-app/1958813/6 "2022-07-10T11:20:33Z")
The link you provided for the Google sheet is not working. You need to make it shareable so others can see how your data is arranged and provide suggestions for you to build your app. ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 11:33am UTC](https://community.thunkable.com/t/interactive-app/1958813/7 "2022-07-10T11:33:56Z")
> **[Test-for cash collection](https://docs.google.com/spreadsheets/d/1xQwSRo067iAzLrgSB3ITh3JCi4DLHQTeZJMw3b2tD_8/edit?usp=sharing)** > > Sheet1 > > Order ID,Dispatched On,Vehicle ID,Driver,Total Fare > 22004646,01-Jun-2022 00:32,L16563,224 - Saddam Hussain - +971565337703,191.1 > 22004463,01-Jun-2022 05:35,L28162,16 - Zafer Khan - +971565251357,498.75 > 22004640,01-Jun-2022 06:16,L28793,23 -... I made it sharable now you can check the data ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 11:58am UTC](https://community.thunkable.com/t/interactive-app/1958813/8 "2022-07-10T11:58:24Z")
I have to say an app is better for such situations but your problem could be solved easily by filtering Data ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8b46be904a76578189b4cf4979d82b57097d2541.png) This is your sample data, I added a column and also selected two random rows and entered a “Y” in the new column. I added a new “Sheet” to your file and copied the same headers from Sheet1 In row 2, I added the following formula ```auto =filter(Sheet1!A2:E1096,NOT(ISBLANK(Sheet1!F2:F1096))) ``` This is the result in Sheet2 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/8/f8ab6027d23316c594baf2bc460f1d738982c1b3.png) Anytime you enter a “Y” (or any other character) in the new column in Sheet1 it will automatically appear in Sheet 2. Have fun. ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 12:07pm UTC](https://community.thunkable.com/t/interactive-app/1958813/9 "2022-07-10T12:07:51Z")
[https://x.thunkable.com/copy/3606dcee00437719a892ddcd1d64ac67](https://x.thunkable.com/copy/3606dcee00437719a892ddcd1d64ac67) this is my project link, can you help me in building the app… as per my requirement We have 10 taxi with us were driver does the cash trip and keeps cash with him… The another Employee who collects the cash is not having information from which driver how much cash to be collected… We can save Date wise & driver wise cash trip details in google sheet. when collector visits in 1 or 2 or 3 days, he should able to see driver wise how many trips and how much cash to be collected… Then he need to check those entries and submit so that we will come to know how much cash is collected by the collector. Those collected entries should not reflect later on his app. Order id will be the unique number for each trip ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 12:10pm UTC](https://community.thunkable.com/t/interactive-app/1958813/10 "2022-07-10T12:10:32Z")
you can whatsapp me on +917204090131 ---
**Author:** ![zander](https://avatars.discourse-cdn.com/v4/letter/z/ecb155/32.png) [@zander](https://community.thunkable.com/u/zander)\ **Post date:** [July 10, 2022, 12:31pm UTC](https://community.thunkable.com/t/interactive-app/1958813/11 "2022-07-10T12:31:21Z")
If you are looking for a freelancer to help you with building the app. Please reach out to [cassandra@thunkable.com](mailto:cassandra@thunkable.com) and she will take it from there. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 1:01pm UTC](https://community.thunkable.com/t/interactive-app/1958813/12 "2022-07-10T13:01:59Z")
You will need a lot of work on this to make it a decent app. I saw your project and added a `List Viewer` so you can select the **driver**. Once selected the upper `Data Viewer List` will only show the records related to this driver. See the example. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/c/5ce645ac76dcb6c194732826e5863d36116a3fa4.png) You can use this as a starting point. ---
**Author:** ![fareedxz](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@fareedxz](https://community.thunkable.com/u/fareedxz)\ **Post date:** [July 10, 2022, 2:39pm UTC](https://community.thunkable.com/t/interactive-app/1958813/13 "2022-07-10T14:39:04Z")
> [@muneer](#): > > `ist` will only show the records related to this driver. Thanks, can i get the blocks how to do it in my app ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 10, 2022, 3:38pm UTC](https://community.thunkable.com/t/interactive-app/1958813/14 "2022-07-10T15:38:01Z")
This is the project [https://x.thunkable.com/projectPage/62cac8196b0d63001220c698](https://x.thunkable.com/projectPage/62cac8196b0d63001220c698) You may use it as a starting point. Should you need a development service then you may send to Thunkable staff as explained by @zander > [@zander](#): > > Please reach out to [cassandra@thunkable.com](mailto:cassandra@thunkable.com) and she will take it from there. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [October 8, 2022, 3:38pm UTC](https://community.thunkable.com/t/interactive-app/1958813/15 "2022-10-08T15:38:17Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.