# Extra Row is Creating Instead of Updating the Intended Row

**URL:** https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449
**Category:** Ask for Help
**Created:** [September 16, 2022, 12:22pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449 "2022-09-16T12:22:40Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 16, 2022, 12:22pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/1 "2022-09-16T12:22:40Z")

</div>

Dear Community

We are trying to update a Row in Confirmation Table (Tab) via another TAsk Tab via a Form.

 ![Update 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/5282b6edf249d6aaa09f5717def387caa105a914.png)

When click on Create Application Invoice, destination is Confirmation

 ![Destination](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b505c3164fcd763795805cb89c5a2cbb844dfb03.png)

We have also Custom Action

 ![Custom Action](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/4734f18d28a823fd71f282e490b2ace24cd5fdba.png)

We are not sure why the intended data is not updated to the right row, but created in as another row in Confirmation!

 ![extra row](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d02662975d07b3e52cb3038c1312f3d4be2e468.png)

We have managed to perform the required 1 day back. But when we added another Create button, this does not work any more.

Any advise is much appreciated!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 16, 2022, 12:31pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/2 "2022-09-16T12:31:26Z")

</div>

> [@ichilddev](#):
>
> When click on Create Application Invoice, destination is Confirmation

Have you tried changing that to use a different Destination Table/Sheet?

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 16, 2022, 12:39pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/3 "2022-09-16T12:39:34Z")

</div>

@Darren_Murphy Hi Darren, changing back the main tab i.e. Tasks should be able to work, but will need all the required fields into Task Table.

However the logic that we have set up should work, and we are still trying to figure out how Glide treat such flow and the limitation.

The main point is why a new row is created when we didn’t indicate so.

Does it have to the with the form we have use i.e Show New Form, Show Edit Form etc. ?

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 16, 2022, 12:47pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/4 "2022-09-16T12:47:31Z")

</div>

We have used Show Form and Show Edit Form to try to get the effect

 ![Trying to create a new update form from Action button](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9ea604988ef00be3b54beb4ae4b292ed1d8f16e8.png)

Show form gives an extra row.

Show Edit form cannot be used, because once we wanted to set up the components, it affect the destination tab Edit form

 ![Change the Edit form here](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3cb11602cc9b33fe476010d44289b1a6eed68e40.png)

The whole of this will be affected

 ![Change the Edit form here 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48321dab6c746a8b8ec28b8b36d8027cc48cd561.png)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 16, 2022, 1:00pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/5 "2022-09-16T13:00:55Z")

</div>

The Form screen’s sole purpose is to add rows. As soon as you click on the submit button, it adds the row. That’s what it’s designed to do. A Form screen is not meant to edit an existing row.

You may need to use something like ‘Show New Screen’ and create a custom edit screen to update an existing row.

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 16, 2022, 1:07pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/6 "2022-09-16T13:07:44Z")

</div>

Got it! Let me try!

New screen cannot have special components to update certain fields by default though.

What about Edit Screen? Can we have different Edit screen when required?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 16, 2022, 1:20pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/7 "2022-09-16T13:20:18Z")

</div>

You can’t have different Edit Screens. You an only have one Edit screen and it’s permanently linked to the table.

A custom action could write special values to certain columns before opening the new screen. Or you could set up your custom edit screen so you fill user specific columns, and then add a button that writes those users specific values and special values to the existing row.

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 16, 2022, 2:01pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/8 "2022-09-16T14:01:23Z")

</div>

Thanks for your reply.

Let us check and work on it.

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 17, 2022, 7:53am UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/9 "2022-09-17T07:53:08Z")

</div>

Hi hi

Realised that when i use a show New Screen to create the form, when values are keyed into the form,

 ![Show New Screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a3bf18973a0f65d726fc6801d5008585da8ed36.png)

The “buffer” values are updated on first row, causing the first row data to be incorrect.

 ![When Use New Screen First Row is updated whenever the Data is updated](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1ffe58137d9de8cad783d51a4c24871be234c8ad.png)

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 17, 2022, 7:58am UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/10 "2022-09-17T07:58:11Z")

</div>

Yes, that’s expected behaviour.  
If you want to use Show New Screen, then the target (Data) needs to be “This Item”.

---

<div class="post-metadata">

### Author: ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)
#### Post date: [September 17, 2022, 8:27am UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/11 "2022-09-17T08:27:51Z")

</div>

Thanks

This Item refers to the current Row ID in this Tab / Table?

Kindly advise where can i read up on this This Item, References etc?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 17, 2022, 8:31am UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/12 "2022-09-17T08:31:37Z")

</div>

> [@ichilddev](#):
>
> This Item refers to the current Row ID in this Tab / Table?

Yes, that’s correct.

> [@ichilddev](#):
>
> Kindly advise where can i read up on this This Item, References etc?

I don’t know that there is any specific documentation on “This Item”, but what you are doing there is essentially creating what’s commonly referred to as a Custom Form. To learn more about that, you can make a copy of the concept app in the below thread and study it.

> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

---

<div class="post-metadata">

### Author: ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)
#### Post date: [September 17, 2022, 9:55pm UTC](https://community.glideapps.com/t/extra-row-is-creating-instead-of-updating-the-intended-row/49449/13 "2022-09-17T21:55:40Z")

</div>

Even though there is only one edit screen, you can set visibility conditions to the edit screen components to have one set show under one circumstance, and another set show under another circumstance. This won’t always be the best solution, but it works great in some cases.
