Action is not reading a cell properly

Ask for Help
1

I have an action with a condition to look for an empty cell and execute it. However, this does not happen, and I know the cell and other cells are empty. What could be the problem?

BSS

2

What’s calling the action? Is it being executed from a component that’s connected to the row with the empty cell?

3

The action is being called from within a Block in a Form. I hope I am stating this correctly.

4

And I have a condition in the Action. If the cell is empty, do this, else do something else.

5

Gets a little tricky in a form.

Is the value your action is trying to look at coming from the parent row where the button to open the form islocated? Or is it supposed to come from a value set within the form?

Have you done anything to verify if the value of filled or not, such as adding a text component to your form that works display the value?

6

I would say it is a value in the parent row. I deliberately went into a specific cell and deleted the data out of three cells and then one of those cells I asked it to see if it was empty but it says it’s not empty.

7

I also forgot to tell you that this data is coming from a Google sheet.

8

Just gotta ask… did you replace the value in those cells with a space character, or are they truly empty?

Otherwise, I think I’m going to need to see screenshots and/or a video to fully understand how everything is set up.

9

I will send you a video

10

This data is coming from a Google sheet. Thanks.

https://youtu.be/shjryb7XucM

BSS

11

I think the problem is you’re expecting that button to look at your whole table and do a set column on any rows that are “empty”, but in reality that only interacts with the row where your screen is built on. That row is “not empty”, so that’s running as expected.

12

Well, what are you saying to do?

13

This morning, I created a table in Glide and created an Action to see the empty cell and to Set The Column values and it worked perfectly. I am wondering whether there is something about data coming from a Google sheet. Any comments?

BSS

14

However, when I added another empty cell in the same Test Table, the Action did not see the new empty cell.

15

I am sorry for another post. The action seems to see the first cell, but not the second or third empty cell.

16

It seems the empty cell has to be at the top of the table for the action to work correctly. Still testing.

17

On the top level of a screen you will be connected to the first row of a table.

You could create a one row table and use that as the driver of your screens. Or if the user will be signed in the user profile table is another good option.

May I ask what are you trying to do?

18
  1. A user is completing a Purchase Requisition form created in Jot Forms.
  2. That form is integrated into a Google sheet.
  3. When a new requisition is completed that new is added to the Google sheet.
  4. Glide is linked to that Google sheet and that new row is inserted into Glide.
  5. The inserted row is accomplished but there are four blank/empty cells in the Google sheet table in Glide
  6. My goal is to have Glide set values in those empty cells by clicking an action. The purpose of this action is to inform the treasurer of the status of those rows to pay later. This could be one row or 5 rows. Depending on how many PR are created.
  7. The cycle ends and will start again when a new PR is created.
    BSS
19

This is why I asked the following question earlier. Actions act upon on a single row. The row that the actions looks at depends on which row the screen with the button was attached to.

  • If you have no filters on the screen then it usually attaches to the first row.
  • If the screen is filtered, then it will attach to the first row that matches that filter.
  • If you apply a sort order, it will attach to the first available row matching that sort.
  • If you have row owners, then it attaches to the first owned row.
  • If you got to that screen by selecting an item in a collection, then you it will be attached to the selected row.

If you want you action to work with a row that has empty columns, then you need to be on a row with empty columns.

Wouldn’t be easier to just show a filtered collection on the screen? Is there no way to get Jot forms to prepopulate those columns?

2 Likes
20

You made a good point here. But please explain more about the filtered collections on the screen. Also, it may be possible to populate the Jot Form with the missing data first.