Hi Im currently struggling
i have 4 tables which have a specific column that i need for my totals table
and i want to know how to get it into my totals table in one row to do a sum
is there a way?
Hi Im currently struggling
i have 4 tables which have a specific column that i need for my totals table
and i want to know how to get it into my totals table in one row to do a sum
is there a way?
You can use query/relation and lookups to bring the information in one table. Then, use rollup to do the calculation!
i tried doing that but it does not seem to work , because when i do the relation it seems blank
so i just stored it directly to the totals table however this is what happens now , so i just want those 4 columns to be in a row
You could use make array column to merge the 4 columns and a single value to get the first element of that array.
Edit
Simpler version:
Use an if then else column to show the column that contains something.
How do i do that exactly, due to im fairly new to glide so i tried doing the array column and this is how it came out
I would do the if than else instead. Sorry changed my mind, if then else will take one col less.
Create an if then else column and set the following:
If col 1 is not empty => col 1
If col 2 is not empty => col 2
If col 3 is not empty => col 3
If col 4 is not empty => col 4
Else nothing.
seems that did not help , unfor , im going to try another way to work around it
appreciate the help
Let’s back up a bit.
How is data being put into this table? You really should be using relations/queries with a rollup (or just a Rollup) so the totals are dynamically updated, but I don’t see any. I just see static number columns and I suspect you are adding rows to permanently write each individual total. What happens when the total needs to change? Also, your table should only have one row.
You mention that you tried relations/queries, but didn’t go into detail what you tried it what didn’t work. Even so, maybe all you need is 4 rollup columns each pointing to each table. Hard to say without knowing what your specifics are for each total.
(You shouldn’t need any Lookups if you are just doing Rollup against a table or a relation/query.)
So i got 4 different tables which is production 1 - 4 , in the tables i have a math column called Pads Manufactured , i want that specific column in my totals table for each essentaily and sum from production 1 - 4 for that specific column
Keep in mind , each of the tables is linked to their own workflow that submit and stores the data to the relevant table
So if there is a way to get that specific column to store in one row from prod 1 - 4 in my totals table , would be awesome
Can’t you just add 4 rollup columns (or single value columns if you just need a value from one row in each table) to your totals table, pointing to the appropriate column in each of your 4 production tables? Then if necessary, add a math column to sum all rollups together?
This is an example want i want , this is permantly stored
I made a mistake in explaing , i do apologise.
production 1 and i save the latest data from the pads Manufactured 1
i want to take that last saved data of the manufactured 1 - 4 and use it for totals tables , i dont want to use the column , i just want to get the latest saved of the pads manu , and sum that from prod 1- 4
as seen on picture , 20000 is the last one stored
i just want to use that number and use it in my totals from prod 1 -4 and sum that
Create 4 single value columns that pull the value from the last row in each table. Then use a math column to add the 4 single value columns together.