How to update data?

Ask for Help
1

Hi, i want to create a workflow that a user can click a button and can be assigned to 10 rows in my contacts table, but i cant seem to do it.
Currently users are assigned by having their email written in column A of my contacts table.
The users email is kept in the user profile.

Please let me know, how i can do this?

2

Which Glide Plan are you on?

I am asking because unless you are on a paid plan, your options may be limited (or at least different).

3

I am on the business plan

4

I have multiple users who are going through a contact list and reaching out to them and recording the result of the interaction.
I want to make a button where the user can request additional contacts when their contact list is empty without an admin having to manually put their email in column A.
I am able to create a button that will pop up when the users contact list is empty and link it to a workflow, but i dont know how to create a workflow that will do what i need it to do.
I need the workflow to find the next 10 rows in my contact list that are empty in column A and to add the users email (in the user profile) into each of the 10 empty rows.
Please let me know how i can do this

6

so i need a solution of how i can have the button above can add the user email into the next 10 rows that are empty in column A

7

Okay, the easiest way to do this is with a Loop. I would use a combination of a User Initiated and Webhook Triggered workflows.

  • The Workflow attached to your button should use a Trigger Webhook action to call the second workflow, and pass the signed in users email as a parameter.
  • In the second workflow, create the following steps:
    – A Query JSON node, to extract the email address from the trigger request payload
    – A Loop that targets your contacts table, filtering where Caller is empty, and limited to ten rows
    – Within the loop, use a Set Column Values node, that updates the Caller column in the current row.
8

Please can you give me a step by step guide on how i can set this up?