Forum Discussion
Solved
Create a row in a table based on changed date in another table
I want to create a row in a Table2 based on weeks in Table1. Table1 has a record of numbers in 10 columns each having date I need to get the average of each column in Table1 for a week and show it ...
Does the screenshot show the " error " in the date column? If so the column width needs to be adapted to the size of the data. If you increase the column width the dates are displayed as intended.
Does this return the intended result if the project is included?
It is working well
-I want to change the green table but then the date column is showing an error ####
-Can I also separate the weekly averages with 'project' sorting? (In my earlier screenshot)
Does the screenshot show the " error " in the date column? If so the column width needs to be adapted to the size of the data. If you increase the column width the dates are displayed as intended.
Does this return the intended result if the project is included?
- This works Perfect!
- I tried to add two columns 'Input Question 1' and 'Input Question 2' and in the blue table it added without any error but when I tried to add it in the green table, it shows an error.
- I tried it to add in Query itself but couldn't get it right. What I wanted is that for each Project the user can give a free text in these two columns and this should be lined with the respective project in the green table