# Create detail transaction
**URL:** https://community.glideapps.com/t/create-detail-transaction/71083
**Category:** Ask for Help
**Created:** [February 23, 2024, 3:13am UTC](https://community.glideapps.com/t/create-detail-transaction/71083 "2024-02-23T03:13:30Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [February 23, 2024, 3:13am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/1 "2024-02-23T03:13:30Z")
Hi, i would like to create detail transaction every single data in list,
the output would be displayed in datagrid and filtered by selected data.
(currently display all data from any transaction).
currently the data store in one table.
kindly, how to make it happen?
cheers
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 23, 2024, 3:15am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/2 "2024-02-23T03:15:48Z")
Use a screen filter on the Data Grid component.
> **[Screen Values | Glide Docs](https://www.glideapps.com/docs/reference/values/screen-values#filtering-collections)**
>
> Values that you can access from the current screen.
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [February 23, 2024, 3:25am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/3 "2024-02-23T03:25:19Z")
Hi Darren thanks it’s works.
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [February 23, 2024, 7:56am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/5 "2024-02-23T07:56:43Z")
i want to summarize every transaction group by nama UPT in jumlah collumn.
 (detail\_trans table)
 (master trans table)
as example bekasi have 2 data, what i do now trying create relation between master trans table and detail\_Trans table but unsuccessfull, may i got wrong step?.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [February 23, 2024, 10:10pm UTC](https://community.glideapps.com/t/create-detail-transaction/71083/6 "2024-02-23T22:10:31Z")
@abba,
What’s the column type of the NAMA UPT in the master trans table? You can create a relation in the master trans table. It would be match with NAMA UPT column and detail\_trans table Nama UPT column.
Also it would be great to use Row ID’s here because it’s safer and easier! So instead of storing the name in the detail\_trans table, store the master trans table’s related row id and create the relation based on the row id.
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [February 26, 2024, 1:58am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/7 "2024-02-26T01:58:35Z")
NAMA UPT creating using text plugin from column NAMA LHA (text type)
i’m trying to create relation Rel\_NAMAUPT using NAMA UPT Column and the result is row id.
is’t possible if relation using row id otherwise the row id is different value in both? and how to make row id automatically insert in detail\_Trans.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 27, 2024, 12:07am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/8 "2024-02-27T00:07:20Z")
> [@abba](#):
>
> i’m trying to create relation Rel\_NAMAUPT using NAMA UPT Column and the result is row id.
If I understand you correctly, the relation is not the “result”. If you want a value from that relation, create a lookup on top of it.
> [@abba](#):
>
> and how to make row id automatically insert in detail\_Trans.
Have you tried using a special value inside a form when you create the detail\_Trans row?
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [February 27, 2024, 2:50am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/9 "2024-02-27T02:50:39Z")
> [@ThinhDinh](#):
>
> Have you tried using a special value inside a form when you create the detail\_Trans row?
No, i haven’t. i’m new glide user and interesting to explore glide feature, could you please show an example about special value, thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 27, 2024, 2:21pm UTC](https://community.glideapps.com/t/create-detail-transaction/71083/10 "2024-02-27T14:21:39Z")
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [March 1, 2024, 7:18am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/11 "2024-03-01T07:18:00Z")
@Jeff_Hager
i can’t found that feature, i’m free plan user, is’t subcription feature?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 1, 2024, 11:11am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/12 "2024-03-01T11:11:48Z")
Where are you trying to add it?
Those special values are only available inside forms.
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [March 5, 2024, 3:51am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/13 "2024-03-05T03:51:37Z")
i’m looking in layout tab, no one
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 5, 2024, 4:29am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/14 "2024-03-05T04:29:35Z")
Are you using a Form Screen or a Form Container?
I can’t tell from your screen shot.
If it’s a Form Container, then special values are added via the “Additional Columns” section in the right hand panel.
---
### Author:  [@abba](https://community.glideapps.com/u/abba)
#### Post date: [March 6, 2024, 1:18am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/15 "2024-03-06T01:18:20Z")
@Darren_Murphy got it, thanks 👏
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 13, 2024, 1:18am UTC](https://community.glideapps.com/t/create-detail-transaction/71083/16 "2024-03-13T01:18:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.