I’m using custom actions to log a set of workout data upon completing the workout. The user enters info and checks off workouts as they go and the data is sent to user specific columns. There are 13 workout types, so the user specific data ends up in 13 different rows. After completing all 13 worko…

I’ve been reading through other posts to try to learn more and I found one from @Robert_Petitto that may help in my situation. Robert showed a way to add multiple rows at a time and within that, he talked about using a single value column to pull up data so it would all be on the top row. I’m going…

Sure, I don’t have them set up exactly how I would want them because I was just trying to get it working first. On the Monthly Challenge table, I originally had one column named “Complete” to designate when the workout had been completed, but then I tried adding them individually denoted by “C_‘wor…

Okay, yes I see. mmm, what you have there is a little cumbersome, and there will be some challenges. For example: In your records sheet, you have a single column for Notes. But in the Challenge sheet, you might have several rows with Notes attached. So to condense all those into a single row you’…

Yeah, the two tables don’t match up well currently because I played around with them after I originally created them and changed columns in one table without updating them in the other. I’ll set it back up for what would be ideal and repost screenshots tomorrow. Thanks, I’ll look into Joined Lists …

No worries. I’m kinda busy right now, but I’ll try and have a think about it later, and if I come up with any ideas will let you know.

I went ahead and set up my “Monthly Challenge Records” table how I would ideally like to have it with some example data. [Screen Shot 2021-04-09 at 2.44.03 AM] Now I need to: figure out the most efficient way to set up the “Monthly Challenge” table My initial thought would be to have single us…

Okay, so after thinking about it (whilst I was driving home :slightly_smiling_face:), I would actually approach this quite differently. Here is what I would do: Firstly, I’d get rid of all those User Specific Columns in the Challenges sheet, and just leave one - a boolean. This would be used for …

Thanks for taking time to think through that and write out your suggestions! Initially, I’m concerned with recording a new row in the Record table for every workout for every user. That would be 14 rows per user, per month. The gym has about 100 members. I’m hoping to store at least 1 year’s worth …

[image] Clifton_Crouch: I wasn’t sure how to capture the individual values for the new row in the records table for each workout if they weren’t stored in their own column. You’re building with a spreadsheet mindset in a database world. Working in the Glide table, that looks like a spreadshee…

Wow that’s a lot to think about whilst driving. Me = ‘why is there so much traffic on the roads today’ :wink:

Singapore traffic isn’t that bad these days :grin:

Add Row - Capture Data from Multiple Rows - #24 by NoCodeAndy - Ask for Help

Topic		Replies	Views	Activity
Is it possible to create multiple records from one entry? Ask for Help	27	2079	October 20, 2022
Dynamic row count in Helper Table for Miracle method Ask for Help	16	119	November 1, 2024
Long Form guidelines Ask for Help	25	1304	September 4, 2021
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5238	May 31, 2020
Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations Feature Requests	55	3412	July 21, 2025