Create detail transaction

Hi, i would like to create detail transaction every single data in list,
image

the output would be displayed in datagrid and filtered by selected data.
image
(currently display all data from any transaction).
currently the data store in one table.

kindly, how to make it happen?

cheers

Use a screen filter on the Data Grid component.

1 Like

Hi Darren thanks it’s works.

1 Like

i want to summarize every transaction group by nama UPT in jumlah collumn.

(detail_trans table)
image (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?.

@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.

1 Like

NAMA UPT creating using text plugin from column NAMA LHA (text type)
image

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.

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.

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

1 Like

@Jeff_Hager
i can’t found that feature, i’m free plan user, is’t subcription feature?

Where are you trying to add it?
Those special values are only available inside forms.

2 Likes

i’m looking in layout tab, no one

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.

2 Likes

@Darren_Murphy got it, thanks :clap:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.