# Automation Learning Help needed
**URL:** https://community.glideapps.com/t/automation-learning-help-needed/87534
**Category:** Ask for Help
**Created:** [August 3, 2026, 1:55pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534 "2026-08-03T13:55:31Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 3, 2026, 1:55pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/1 "2026-08-03T13:55:32Z")
This is my current app and I made a temporary placeholder button showing if the current fixture is in use or available I want to trigger a mini tab to open up and then ask for the employee’s name and signature and automatically save that information and switch status from In Use to available and vise versa.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 3, 2026, 3:32pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/2 "2026-08-03T15:32:45Z")
I imagine you could set a “Show New Screen” → “This Item” action on the button, set it to be an overlay or slide-in, and then put whatever inputs you need on that screen.
---
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 3, 2026, 5:36pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/3 "2026-08-03T17:36:11Z")
Thank you this is as far as I have gotten so far, however nothing actually works I need help creating a workflow that will automate the switch between Returning something to Shelf and taking it out so the persons information is saved until next time.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 3, 2026, 6:10pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/4 "2026-08-03T18:10:38Z")
Can you explain how your data is setup? How do do you determine that an item is checked out or not? Do you want do store the status direct in the the item row, or are you creating a log in another table? Based on your screenshot, it looks like you are using a form to add a row to a table. How are you using that table currently? Do you have a relation or query set up between the item and the log?
Need some more info to fill in the gaps so I don’t assume in the wrong direction.
---
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 4, 2026, 3:03pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/5 "2026-08-04T15:03:29Z")
Here is what I have so far I was experimenting with the relation and query set up, trying to learn from videos online however I am still quite confused, if it’s not too much of a bother would you be free anytime this week to meet on a zoom call or something like that so I can learn from you?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 4, 2026, 5:15pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/6 "2026-08-04T17:15:50Z")
I think you are on a good track with the log, but what I would do is add a relation to the fixture table that links it’s fixture id to the fixture id in the log table. Then create a Single Value column and set it to Get Last from the Relation → Whole Row. That will link each fixture to the last log entry for each respective fixture. From there you can add lookup columns that pull individual column values from the single value row and use them for any button workflow action conditions or use them to display any log text you want on the fixture screen.
---
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 4, 2026, 5:57pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/7 "2026-08-04T17:57:57Z")
Any chance we can join a google meet or zoom to discuss further I am not quite sure I follow?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 4, 2026, 6:00pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/8 "2026-08-04T18:00:43Z")
I usually don’t do one on ones and only have time to pop in and out of the forum periodically.
Where are you stuck? Have you created the relation and single value columns so far?
---
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 7, 2026, 2:08pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/9 "2026-08-07T14:08:10Z")
Sorry Jeff I was out of office but can you specify which table to create each thing in as well as names of the columns you want me to relate things to. The first data is called Fixtures, and the second one is called Fixture Logs.
---
### Author:  [@Gamil\_Henin](https://community.glideapps.com/u/Gamil_Henin)
#### Post date: [August 7, 2026, 2:11pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/10 "2026-08-07T14:11:40Z")
I also don’t understand what the single value and lookup column do or what to use them for in the workflow
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 7, 2026, 3:29pm UTC](https://community.glideapps.com/t/automation-learning-help-needed/87534/11 "2026-08-07T15:29:41Z")
> [@Gamil\_Henin](#):
>
> specify which table to create each thing in as well as names of the columns you want me to relate things to
> [@Jeff\_Hager](#):
>
> add a relation to the fixture table that links it’s fixture id to the fixture id in the log table
You have a fixture number column in both tables. That’s what you will use to establish the relation because it’s a matching value in both tables.
Still in the fixture table:
> [@Jeff\_Hager](#):
>
> create a Single Value column and set it to Get Last from the Relation → Whole Row. That will link each fixture to the last log entry for each respective fixture.
Set Get to ‘Last’ and set From to the relation column you created (be sure to pick ‘while row’ instead of an individual column from the relation. That will provide the last row for each fixture.
> [@Jeff\_Hager](#):
>
> add lookup columns that pull individual column values from the single value row
Lookup columns should pull values from the single value column. Not the relation.
Beyond that I don’t know what your expected flow would be, but the lookup columns will provide individual column values from that last row to do whatever you want as far as using them for visibility conditions, workflow conditions, or just displaying them on the screen.
> **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)**
>
> Create relationships and link rows together.
> **[Single Value Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/single-value-column)**
>
> Retrieve a single value from a column or relation.
> **[Lookup | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/lookup-column)**
>
> Retrieve values through a relation.