# Helper Table per day of the week

**URL:** https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111
**Category:** Ask for Help
**Created:** [November 28, 2022, 6:38pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111 "2022-11-28T18:38:13Z")
**Posts on this page:** 5
**Page:** 2

<div class="post-metadata">

### Author: ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:59pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/21 "2022-11-29T21:59:04Z")

</div>

> [@Uzo](#):
>
> no need for more drivers, because it is USC

Ok, I think that there is something else where I was not clear enough: my objective is that your second table (the one I called [planning]) be 1 row per user, just like if I created a **form**.  
(this by the way answers to your point “_USC data won’t be visible in the app, but only in the dataeditor_”).

So, in my detailed flow, after users have enter their route (in the [helper] table), there is a button with a custom action “add row” in the [planning] table.  
And here, I’m back with my issue with “Single Values” which changes data dynamically…

I think that I should redo everything, with a basic heavy approach and a standard form (eg. multiple columns to be filled-in by the user in only 1 table).

Sorry to have disturbed you and thanks again

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 10:04pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/22 "2022-11-29T22:04:30Z")

</div>

ooooh… you are adding new routes by adding rows to the help table? you should replace data there… not add… but hold on… you said that the user is editing the help table… and adding a new row to the planning table… then what is the point of having single values there if you can copy data from the help table?.. just add a timestamp column to the planning table and get the latest entry from user adding row… and that will be a current route plan… you have a timestamp and user ID… easy to filter… no need for single values columns… it is pure static data…

make a helper table with one row, for all days… so you don’t have a problem with copying data… what is the reason for having days in separate rows?

---

<div class="post-metadata">

### Author: ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 10:18pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/23 "2022-11-29T22:18:52Z")

</div>

> [@Uzo](#):
>
> ooooh… you are adding new routes by adding rows to the help table? you should replace data there… not add

No no, my [Helper] table is fixed (1st one below), I add 1 row per User to the [planning] table (the 2nd one below)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f635e13e7280d6ddcf0047c77f5d64c389c4dca8.png)

> [@Uzo](#):
>
> _just_ add a timestamp column to planing table and get the latest entry from user from user adding row

I love the _just_ it rhymes with simple.  
But in [helper] table my routes are still by day, in 1 column x 5 rows (monday to friday)  
=\> I don’t see how I can add them in 1 row in [planning] table without “single values”

> [@Uzo](#):
>
> make a helper table one row, for all days

Yes, this is what I will do, even if I wanted to avoid it for User Experience purpose: much simpler & quicker to input data in a datagrid with 1 column for days" | 1 for departure | and 1 for destination.  
And in this case I don’t really need the custom form, a basic form is ok.

Thanks

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 10:23pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/24 "2022-11-29T22:23:03Z")

</div>

you can create a 2D grid from 1 row … ! just repeat inline lists 5 times for each day… or whatever you are using 😉

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [November 30, 2022, 10:23pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/25 "2022-11-30T22:23:11Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.

[Previous page](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111.md?page=1)
