# How can I set up a button that changes the value of a single cell? **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2021, 9:40am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340 "2021-12-01T09:40:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ben\_Nicholls](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_nicholls/32/35043_2.png) [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)\ **Post date:** [December 1, 2021, 9:40am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/1 "2021-12-01T09:40:49Z")
Essentially I have a sheet of previous jobs. When a user enters the data for a new job, the app gathers similar previous jobs and from here the app works out an average Rate. I need to be able to set a single cell, the newest JobRate cell, to this Rate that the app has worked out, without touching other cells in the column. Thank you for your time. Ben ---
**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:** [December 1, 2021, 9:54am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/2 "2021-12-01T09:54:32Z")
You just need to navigate to that row (maybe via an Inline List), and then either allow editing, or use a Set Column Values action to update the appropriate column. > **[Adding & Editing](https://docs.glideapps.com/all/courses/introduction-to-pages/adding-and-editing)** > **[Inline list](https://docs.glideapps.com/all/reference/components/lists/inline-list)** > > An inline collection of related items > **[Set Column Values](https://docs.glideapps.com/all/reference/actions/single-actions/data/set-columns)** ---
**Author:** ![Ben\_Nicholls](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_nicholls/32/35043_2.png) [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)\ **Post date:** [December 2, 2021, 1:09am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/3 "2021-12-02T01:09:14Z")
Hi Darren, This method mostly worked, however I can’t set the cell to the value I want, I have no idea why it isn’t working, the button simply doesn’t do anything. Also the button below works but changes the Quote cell of an old job, not the latest one. ![HelpScrnSht](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/0289a21db82d629389462277c1cd7ac98f54d54a.png) Thanks ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 2, 2021, 1:17am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/4 "2021-12-02T01:17:41Z")
the problem probably is, that your screen is not on the same sheet or row that desired value is… use relations to get your value ---
**Author:** ![Ben\_Nicholls](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_nicholls/32/35043_2.png) [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)\ **Post date:** [December 2, 2021, 3:16am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/5 "2021-12-02T03:16:21Z")
Hi Uzo, How am I supposed to do this exactly? other options on the same sheet work, it is just the desired values that aren’t working, anything else works fine. if I sort the sheet backwards the desired value is greyed out, but if I sort the sheet normally the value works but changes the wrong row. Thank you ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 2, 2021, 3:30am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/6 "2021-12-02T03:30:06Z")
is hard to tell exactly, without seeing the app. in general the best practice is to have the current item row id be written to a USC column, first row. then have all items be related to the first row. this way you can access this item ID from any place in the app, regardless of sheet and row you are on ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 3, 2021, 3:30am UTC](https://community.glideapps.com/t/how-can-i-set-up-a-button-that-changes-the-value-of-a-single-cell/35340/7 "2021-12-03T03:30:50Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.