# Bug with sending data via form button from a lookup column **URL:** \ **Category:** Report a Bug\ **Created:** [February 13, 2020, 3:56pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572 "2020-02-13T15:56:07Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 13, 2020, 3:56pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/1 "2020-02-13T15:56:07Z")
My app’s URL: [borrowwamsipad.glideapp.io](http://borrowwamsipad.glideapp.io) In a nutshell, I have a form button feeding a log. In that log I have a field called “Status” which is either “available or unavailable”. I also have an if/then called “Next Status” which gives the opposite status. On a homescreen sheet, I have a lookup column that’s finding both the status and next status of an item. The homescreen displays the current status (Status) and has the form button that send the “next status” to the status column of the log (to complete the loop). The glitch I’m experiencing is that even though I’m sending the “next status” value to the log, the current “status” value is the one recorded. The only thing I can think of is that it’s calculating the if/then in the log prior to the data actually being recorded which then would throw off all the conditions. Thoughts? ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [February 13, 2020, 4:08pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/2 "2020-02-13T16:08:02Z")
Check your if statement - if you’re using a checkbox on your sheet that could be part of it. I had an issue where I was testing a checkbox to be true, and I didn’t need to. My mistake was this: > =if (A1=“TRUE”,B3,B4) It ALWAYS returned the value in B4 for me. After some checking, I found out i didn’t need the “TRUE” because it was a checkbox. If it’s checked, it’s TRUE, if not, it’s FALSE. All i needed was > =if (A1,B3,B4) This gave me the TRUE when the box was checked, returning the value in B3 Hope it helps. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 13, 2020, 4:28pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/3 "2020-02-13T16:28:33Z")
Thanks for the suggestion @Tim_Sullivan, but I’m not using spreadsheet formulas for the if/then…I’m using the if/then/else column in the Data Editor. ---
**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:** [February 13, 2020, 4:38pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/4 "2020-02-13T16:38:20Z")
Just going off of your order of precessing theory, what if you move the IF THEN column after the status column? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 13, 2020, 4:46pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/5 "2020-02-13T16:46:56Z")
In the iPad Status sheet? Just tried it…didn’t work. ![Screen Shot 2020-02-13 at 11.46.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/afb635e929e616468f671493f02966d68a7d1b13.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 13, 2020, 5:18pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/6 "2020-02-13T17:18:52Z")
Related glitch. Instead of the if/then/else column in the ipad status sheet, I created an identical if/then/else in the log sheet. I then did a lookup of that value in the status sheet and attempted to pass THAT value via the form button to the log. Now, it the if/then/else in the log sheet correctly generates the opposite value that was passed to the log, but generates an _ **EMPTY** _ value within the status column. So weird. ---
**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:** [February 13, 2020, 7:04pm UTC](https://community.glideapps.com/t/bug-with-sending-data-via-form-button-from-a-lookup-column/4572/7 "2020-02-13T19:04:40Z")
I studied your videos a few times and your logic seems sound. It reminded me of a similar post where somebody was having the same issue and got around it by displaying the value on the screen. You could put the NextStatus on the form and hide it with visibility as something to try. It sure seems like a bug to me. > [@Could not send a "Lookup" column by Form and workaround](https://community.glideapps.com/t/could-not-send-a-lookup-column-by-form-and-workaround/4000): > > Hey guys, I encountered this problem in Form, which is I couldn’t send a data column to the spreadsheet (it made an empty cell) if the column is created by “Lookup” of a relation. Then I found it works correctly if I use the column as a component. As a workaround, because I did not make it appear, I made a template of \