# 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:** 20
**Page:** 1
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 28, 2022, 6:38pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/1 "2022-11-28T18:38:13Z")
Hi,
In GlidePage, I want to collect users regular routes (departure \> destination), per day of the week. Routes are always the same each week.
I try to use a [Helper table] to create a custom form writing in a [Planning table], but I am missing something.
1/ **[Helper Table]**
It has the same format than the below screen to input rows
(with “USC fields” + columns: “RowID” and “(Template) User ID”
2/ **[Planning table]**
Via a “Single Value”, I bring data from the [Helper table] into the [Planning table], whose format is as follows.
Then with a “LookUp” and “Index search” I’d like to bring the value to collect per day in the [Planning] table (with a different index per day)
**BUT** this is where I am bugging: how make this data fixed, ie. not depending on the “SV rank-x” column?
(otherwise it changes at each change in the “USC fields” in the [helper table], and this is due to the fact that my [helper table] has not a single row but 5, ie. one per day of the week)
I hope that it’s not too confusing…
Many thanks in advance
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 28, 2022, 9:25pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/2 "2022-11-28T21:25:03Z")
very confusing … I assume you want to copy the user route to the datasheet… just show his daily routes as an inline list, and when it is clicked, it will copy values to the related row.
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 28, 2022, 9:54pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/3 "2022-11-28T21:54:06Z")
Thank you @Uzo.
Clearly my description is confusing.
If I try to make it simpler :
I have 2 tables:
**[helper]** table which takes this format in the table & in the user screen
and **[Planning]** table with this one
→ I would like that the data being entered in the 2 columns of the user screen (and [helper] table) be a new row in the [planning] table.
And I struggle with it…
Thanks
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 28, 2022, 9:56pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/4 "2022-11-28T21:56:49Z")
are you sing Glide form or entry fields? is there a problem with the custom action to add a row?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 1:40pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/5 "2022-11-29T13:40:20Z")
A custom form, but don’t see how to move from a table input in columns to 1 row
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 8:03pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/6 "2022-11-29T20:03:57Z")
I can’t imagine what is your flow…
correct me if I am wrong…
you have route data in 5 rows for each day, in the helper table?
you wanna get all 5 rows of data and move them to 1 row in the Planning table? or specific day data into a planing table?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 8:14pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/7 "2022-11-29T20:14:31Z")
Yes.
Basically, the structure is
I cannot reproduce the “miracle approach” of Robert…
Thanks
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 8:25pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/8 "2022-11-29T20:25:10Z")
you are not answering my question… please explain the step-by-step flow… your images are very confusing…
Do you want to take from the list all days and place them in each column for each day in the planning table?
what value goes to “Monday rote” column?
is single value 1 from start… 2 from start … not making a trick for you?
is the helper table fixed? do you have different tables for each user? or is only one user? do you store data for other Mondays… Thursdays…?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 8:51pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/9 "2022-11-29T20:51:20Z")
Sorry, I’ll try to make it more clear.
1. “_Do you want to take from the list all days and place them in each column for each day in the planning table?_” → **Yes**
2. “_What value goes to “Monday route” column?_” → **a template column of each value of each row from the [Helper] table** (cf. green background data)
1. “_Is single value 1 from start… 2 from start?_” → **This is what I used in the custom form (in the other table [planning] where I want to get data in row), but the issue is that it is taking the last value of the [helper] table. I don’t manage to fix the data in this other table.**
2. “_Is the helper table fixed?_” → **Not sure about the question, but I have only 1 [helper] table for all users (thanks to user specific fields), where they enter their routes; I relate to the other tables with a “template column: User ID”**
3. “_Do you store data for other Mondays… Thursdays…?_” → **No because it is the same weekly planning for the year**
Sorry, it’s burdensome
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 8:57pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/10 "2022-11-29T20:57:02Z")
kind of a weird approach to the problem… using USC for planning… you will never see the data for each user in the app… only in the Glide editor…
why Is taking the last value of the table if you set it to take 2nd? so is always taking the Friday route instead of Tuesday if you set 2nd from start?
looks like the solution is easy… … Monday route column should be a single value 0 from start… Friday 4 from the start… is this not working?
or I am missing something in your explanation?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:15pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/11 "2022-11-29T21:15:53Z")
> [@Uzo](#):
>
> using USC for planning… you will never see the data for each user in the app… only in the Glide editor…
The USC is only in the [helper] table, it should then be moved to the custom form eg. the [planning] table. So I will have all data (“routes”)
> [@Uzo](#):
>
> looks like the solution is easy… … Monday route column should be a single value 0 from start… Friday 4 from the start… is this not working?
Yes, this is what I thought, but each time I am changing the USC in the [helper] table, the single value column in the [planning] table are also changing
(illustration of the [planning] table with single value taking the last input from the [helper] table)
> [@Uzo](#):
>
> or I am missing something in your explanation?
I’d rather say that my explanation is 😵💫…and the design of my flow is ☣.
Basically, I designed all this just to enable users to enter their route into a “data grid” in glidePage, where they do 1 input in columns (cf. days of the week) which then must be migrated into a row as a form
If you think it’s too complicated, I will take another route
Thanks anyway
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 9:20pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/12 "2022-11-29T21:20:53Z")
it is very easy… there is something I am missing in your explanation… why did you mention Robert method? why is there a rank? if is fixed data there is no need for that… or you just overthinking this task?
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:31pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/13 "2022-11-29T21:31:49Z")
Yes, exactly what I did, but what happens when I add a “Driver 2”
- 1st table: the user inputs new values
- 2nd table: and due to the use of “single value” columns, it changes the values of all Drivers with the last value taken.
This is at least how it (badly) reacts in my case.
I would need to be able to copy the Driver 1 “single values” in a new text column per day, otherwise it remains dynamic.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 9:34pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/14 "2022-11-29T21:34:10Z")
let me reproduce your case… with USC and more drivers 😉
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:37pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/15 "2022-11-29T21:37:28Z")
> [@Uzo](#):
>
> or you just overthinking this task?
Probably yes!
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:38pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/16 "2022-11-29T21:38:45Z")
> [@Uzo](#):
>
> let me reproduce your case… with USC and more drivers
Even without USC, if you add more drivers in your case and change your first values data, does it work?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 9:38pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/17 "2022-11-29T21:38:54Z")
it works with USC… no problem
I think you are confused by USC… as I said is a bad approach… when you change user… all data will be for that user for all drivers… so there is no need for having more rows in helper table
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:43pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/18 "2022-11-29T21:43:25Z")
You’ve got the same cities for Driver 1 and 2 on Monday and Thursday.
But what happens with
- Driver 1 : monday = city 1, thursday = city 2
- Driver 2 : monday = city **4** , thursday = city **5**
(if it works for you, I move back to Wix 🙂 )
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 29, 2022, 9:44pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/19 "2022-11-29T21:44:49Z")
yes, because is USC… it will show current user data for all drivers… you need regular data… and then use Robert method to pick related user data… or just have 1 driver there… which is the user using the app… no need for more drivers, because it is USC… that will work too… just keep in mind you are dealing with USC no need for other drivers there
---
### Author:  [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)
#### Post date: [November 29, 2022, 9:46pm UTC](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111/20 "2022-11-29T21:46:37Z")
> [@Uzo](#):
>
> you need regular data…
Ok, I’ll try that …
THANKS!
[Next page](https://community.glideapps.com/t/helper-table-per-day-of-the-week/55111.md?page=2)