# Computed Value Different After Using Customer Action ADD ROW to Another Table

**URL:** <https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950>\
**Category:** Ask for Help\
**Created:** [November 26, 2022, 5:55am UTC](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950 "2022-11-26T05:55:52Z")\
**Posts on this page:** 4\
**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:** [November 26, 2022, 5:55am UTC](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950/1 "2022-11-26T05:55:52Z")

</div>

Dear Community

We have a Invoice Main Table with 1 If-Else-Column (we also tried using Template column to get the final values) with this Values that are Guid ID set for each Login User, COmpany Acc, Student Acc etc  
{  
“CreateOperate”: {   
“UserID”: “a0eb62ed-da29-41d8-88eb-179943cc468d”,  
“UserName”: “Luke”   
},   
“InvoiceID”: “c61fe173-fd97-480a-89a9-e9ce236e916a”,   
“PuserID”: “cb05dd1b-50d1-446b-a868-1b5ba5d12925”,  
“ClassID”: “aebbf86a-c7e2-421c-8358-8b821f23a84b”,  
“UserID”: “43167b97-10de-4c96-84bf-fcfc2ff6284e”,  
…

 ![Values Using Relation to Invoice Main](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/92cd3aa449f1d5d7d95719510a4e1eab5d5d9a49.jpeg)

The above are correct values. Using Relation to Original Table

We wanted to export the above values to another Glide Table - Invoice - Temp using the customer action: Add Row:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/6624cd6d53cfba544258787c0704b48ee284a5f0.jpeg)

However all the IDs are different in the Invoice -Temp table

 ![Values using Add Row to Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00fa5f9c8389387b6a1b35a34649fd9ba6be9d6c.jpeg)  
These values using Custom Action: Add Row are not correct.

Kindly advise why this is so and the difference?

Any advise will be most 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:** [November 26, 2022, 7:41am UTC](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950/2 "2022-11-26T07:41:00Z")

</div>

Some of what I see in your screenshots looks… odd.

For example, what is the purpose of this column 👇 ?  
 ![Screen Shot 2022-11-26 at 3.33.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/570de131e7cb5a2437d93036804aee2da2bf2c9d.png)  
I find it really difficult to imagine a scenario where that column makes any sense whatsoever.

Also, it looks like you are inserting a JSON string as a column value, here…

 ![Screen Shot 2022-11-26 at 3.35.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52e7627f07fe5ee1656b8cd6d6bea30ff922ce89.png)  
Is that really what’s intended? Maybe it is, but again it seems odd.

As to why you’re seeing a mis-match in values, impossible to say why without understanding your full setup in detail.

Just out of curiosity, why are you using the API to copy data from one table to another?  
Again, it seems like a really odd use case.

---

<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:** [November 26, 2022, 7:57am UTC](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950/3 "2022-11-26T07:57:44Z")

</div>

Hi Darren, thanks for the prompt reply!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51d5eb70ecc94c622c2f1202d9c5177a0e88ed79.png)

From this screenshot, these IDs are required to be pushed to our DB via API.  
This are the values

{  
“CreateOperate”: {   
“UserID”: “23007da9-72af-4508-99f8-fa250852bfa2”,  
“UserName”: “Luke”   
},   
“InvoiceID”: “c61fe173-fd97-480a-89a9-e9ce236e916a”,   
“PuserID”: “aeb5ad15-5763-46c2-98bc-a005e4c07310”,  
“ClassID”: “f9829540-bf64-41c9-9890-e8333ce6e4e4”,  
“UserID”: “4783bdcb-f40f-4db2-8ee0-1038622216de”

We thought that computed values cannot be read by API. thus we have used another column to record this via Custom Action : Set Column

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/2611cf8deacf1d7c56da280855e688011bdc2e79.png)

but these ID values are different (See UserID = student ID)  
“CreateOperate”: {   
“UserID”: “dd2fb186-b44b-4616-b925-32e838582c3d”,  
“UserName”: “Luke”   
},   
“InvoiceID”: “c61fe173-fd97-480a-89a9-e9ce236e916a”,   
“PuserID”: “8238205f-dd51-49db-a41e-ea6a3b9d9148”,  
“ClassID”: “ce1996d8-f2ee-4954-9c8c-545b0da904bd”,  
“UserID”: “e5e05567-aec3-40fa-acd7-aa24cf024d44”,

 ![1669449170063](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d67ea2af411aa18b90eaf62d5e63626066848f2a.png)

Not sure why is this so.

User ID is the student ID:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d42c667af977b73bb57bc7fe760db6d5c75b9702.jpeg)

The Final Values from Custom Action : Set Column wasn’t from this list.

Don’t know how glide changes these set of values.

All the above values are Lookup from other tables:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f8a8331eaaf62bbde9f886506b9872fe9109f99.jpeg)

From the Various Table, these IDs are generated using Template - Unique Value

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/45050e91da01a8e0bfe0afeef6c3c03115f02495.jpeg)

Could this be the reason?

---

<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:** [November 26, 2022, 8:13am UTC](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950/4 "2022-11-26T08:13:50Z")

</div>

We are extracting the Column values as JSON.

_Just out of curiosity, why are you using the API to copy data from one table to another?_  
_Again, it seems like a really odd use case._

We use a temp table to screen through new rows that need to be updated to our DB, instead of scanning through the whole Original table.

There isn’t much documentation on API, and thus we can only trial and error here and there.

We are using add-row-to-table as shown in the API documentation.
