Hi @Steve!
Its kind of a complex, I try my best to explain how it worksโฆ
I have a table (table 1) where every first day of the month all the students corresponding to each class and each school are added to this table, also the corresponding number of class days are added for each month(all this by a script in Gsheet), and from Appsheet the list is passed to present and absent students. The number of days students have classes never match with calendar days. For class days to be correct, teachers must enter the class days corresponding to each month and as it is not feasible to add students per student on the days of class corresponding to each class, I made a second table (table 2) in Gsheet, where I concatenate the information from (table 1) such as [date] (which is always set on the 1st of each month), [the name of the class], [the schoolโs name] and a fourth column [ class days]. In this fourth column [class days] the teachers add the number of class days corresponding to each month. Then in (table 1) in Gsheet, I have a formula that concatenates the information that I mentioned and I have another column in the (table 1) [class days] that has a formula, that if the concatenation in (table 1 )is = to the concatenation of the (table 2), then add in the cells of the column [class days] in ( table 1) the information of the column [class days] of the (table 2), in all the rows that the concatenation is coincident in (table 1).
So, as in Gsheet I have tried in various ways to concatenate the information, but Gsheet gives me a strange value in between the concatenated values, Iโm looking for the way to do it from Appsheet with a virtual column.
I hope this explain better what I am intended to do.
LinkedIn
Twitter
