Reset Multiple Rows At Once

Hey, @Jeff_Hager love this work!
My question is this, how do I make the parentID change for unique users? Since you are using a Single Value First table type.

It will always be a unique experience for each user because the ParentID on the first sheet is a user specific column.

So how would I set that for something like an onboarding experience? Like how would I target the first row like that?

It’s the same reason I have the Tap to Start button. That sets the ParentID initially. After that, the clear button resets it to a different value. You would have to have an action somewhere in your onboarding process to set that value initially. Once it’s set…especially if you require sign it…then it will always be populated with a unique ID.

Usually if the sheet only contains one row, you can create a Single Value column that points to that sheet, but select whole row. This could be done in your user profile sheet since you are doing an onboarding process. Then somewhere in your process you can perform a Set Column action that sets the ParentID through the Single Value Row. A similar method is to create a Key column, so something like a template column with the word KEY in it. Create a similar template column in the sheet that contains the Parent ID. Then create a single Relation column to link both KEY templates together. Then you can Set the Column value the same way I mentioned for the Single Value Row column.

2 Likes

Hi Jeff! Thx for your post. This is what exactly I was looking for.
I’m not an expert yet to I checked and unchecked thousand of times in order to undersand. I got it! dont laugh :slight_smile:

In my case it a little but different.
For instance, I have:
Total Donation Record USD 100
- 1 of 2 quota USD 50
- 2 of 2 quota USD 50
Total Donation Record USD 200
- 1 of 4 quota USD 50
- 2 of 4 quota USD 50

User can select 2 quotas of different Donation Record (I’m setting columns SELECTED), so I guess, I cant use Unique Identifier since I will working in two records of Donations Records.

How do u suggest to Reset these rows?
I hope u understand me.

Thx so much in advanced

I have a solution for this in my expense management application.
Branch heads can approve multiple expenses using one button provided that they are not already rejected previously or later.

Check out the video here:

10 Likes

Great :+1:

1 Like

Thanks @Manan_Mehta. Is that adaptable to be able to be done per user? That is, how could I open up a filtered list that shows a specific user’s expenses, then only approve that user’s expenses? I’ve tried doing this using a template column to pull in the date and email address of the row, but since tis a template column, it’s no longer a date that can be before/after the current date. Curious if you’ve used similar logic to allow this sort of process. Thanks!

The video I sent is specifically for individual users. The approval date and time value is written in the user’s row only.

I am writing data on the user profile sheet so I don’t need to pull in the user’s email address. Let me know if you are confused.

Ahh sorry I understand now! Thanks! I’m going to find some time to play with this. Appreciate the quick reply!

1 Like

Hi @Jeff_Hager, thank you for this workaround. To workaround its possible limitations with Edit/Form/Add, what I did is:

  • Create a form with 1 field (ex. Title) just to initiate the new row
  • In the detail screen, I have all the other fields and combine “entry” and “display” fields, with visibility conditions (according to the user, ie. creator or visitor)

At the end of the day, just to get a “multi select choices” capability, usable in various types of screens (forms…), implies a lot of complexity and columns. Hopefully, a native Component (which is quite a basic) will soon appear as a fantastic surprise ! @Mark @JackVaughan

3 Likes

Thank you so much @Jeff_Hager ! I was able to use your awesome method successfully in creativitae.glideapp.io. What a pleasure it is to see the toggle between red and green emojis and to clear all selections at once.

1 Like

Hi Lucas, can you explain in spanish how to do a select_all an reset? I dont understand the Jeff explanation
Thanks

1 Like

Hi @Manan_Mehta Manan,
Thanks for the video!
I’m a beginner and I’m looking for something similar to your movie. I want to use a button to approve a column value in multiple rows. I just don’t understand how to control the button you use. Do you have a picture of that (how to act)?

If you have time could you show a little more settings for each column, please?

1 Like

Hello Sabiene! Apologies I haven’t seen this message for all this while. Are you still looking for a solution to this?

1 Like

Me too… :confused:

I see my answer is not there at all. but yes i would really like some help. what do you need from me to help?

Hello @Sabiene and @victorpr here’s a simple explanation of how it can be achieved.

Also here’s the app link if you want to play around: https://manans-project-f3zc.glide.page
Feel free to hit me up if you need any further clarifiaction.

6 Likes

OMG I think I got it working! Thanks to your video I built everything up again step by step and I am now satisfied with how it works. Thank you for the effort you took to make this. (Unfortunately I couldn’t look into your app it needed an email.)

1 Like

Hi @Jeff_Hager , I tried to reproduce your app in my usecase with copying the way you did your app in mine, but i have a problem with the Clear all or tap to start button : when i want to set column values of “this item” ‘Parent ID’ to Unique Identifier, the button disappear. I read that it means there is a problem in the logic, but i can’t see why. Can you help me please ?