Working with Deep Bin Grids

In this video we go trough the process of creating Deep Bin Grids.

*Deep Bin* is Low-code database app builder and online data editor for custom menus, pages, grids, workflows, and data entry forms.

👍 *Like & Subscribe* for more tutorials and updates!

🔗 *Download Deep-Bin*
Try it yourself:
https://www.etl-tools.com/products/deep-bin.html

📌 *Got questions?*
Ask them on our support forum!
https://www.etl-tools.com/forum.html

👍 *Enjoyed this Tutorial?*
If this video was helpful, consider giving it a thumbs up and **subscribe** to the channel for more tips and tutorials!

🔔 *Stay connected!* Don't forget to turn on notifications for future videos.

#DeepBin #DataIntegration #DataEntry #DataEngineering

---

Closed Caption:

Everyone, this is tutorial. I'm going to
talk about editing team beam
grids.
So, grid is just a table
which you can see on the screen right
now.
On the top it has number of actions.
It also has
some default actions like export data to
Excel, import data from Excel, refresh,
or reload.
And you are also choose which fields you
want to see.
And it has uh
uh
incremental search.
And it has list of fields which is user
definable.
And it has row actions. For example, you
can add a row action to like edit the
data or link to something else.
Uh you can edit it by pressing edit
button.
Or you can edit it by using row format
which is quite often easier.
So, here we have the code
which is used as a part of the link.
And we have the name.
Again, this is the title.
And we have design. A grid is based on
the uh model.
So, we have number models here.
Uh
for data input, we recommend using
metadata lookup value lookup
tables.
It is more than enough to uh
enter any data you want because it has a
lot of additional fields.
Uh on the top we have title.
Then we have what to show. So, all
records with paging.
Records per to page 50. So, if uh
the table has more than 50 records, uh
you'll get multiple pages.
Then you can hide toolbar. Then you can
hide search or additional data or
clear button.
And this
plus and minus allows us to create
actions on the top.
Click plus, so here is another action.
We can in fact move it around.
Like this.
Or we can
delete last action.
So, if you click on action, we can edit
it. So, this action is actually this
action is adding new record
to reservation form.
And again, it has a label.
And it has show heat, and it has plus
button as icon.
You can also align it to the right.
Like this.
And we can open a new window.
Now, if you click on the grid,
we can edit list of fields. We have
eight fields on top row. Let Let's me
show one of them.
So, what can we have here? We can uh
There's a label.
This is the actual field from name from
the model.
And then we have hide field option, and
we have format. The format can be text,
number, date, date time, or image.
We can also say that we would like to
use like search,
which can be very useful if you have
very very large table. Please bear in
mind that like search only works for
text fields.
We also have row actions. In our case,
we have only one row action.
And again, this is this action is using
a form
for editing the data, and we pass ID as
a parameter, ID field.
Again, we can show for and we can show
the icon.
Then we have data filters. Data filters
are very useful.
In this case, we are we are saying that
we are only interested uh
in the fields where metadata ID is equal
to two.
And uh char field uh 02 is equal to
result.
So, we are only showing result records.
Then we have uh data sorts.
We are saying that we are sorting our
data by this field.
And that field.
And we also have data export. Data
export is used for uh exporting data to
Excel.
Here we are saying that, for example, so
here is a field name.
Here is the label. Here is the type.
Excel number.
And once data exported, we can import it
back.
Let me show. I'll just click cancel.
Go to, for example, uh ratings.
Reservation.
Click export data to Excel.
Here is the file. This one You see this
field, it is numeric, so it is aligned
to the right.
And that one is numeric, so aligned to
the right. Hello.
Uh
First uh topic is saying uh about uh
is just showing the 36.
And explains how to make sure that we
can import data back.
Then this is another one. This talks
about beta data. So, this is the actual
field name.
Here is our data. Again, as you can see,
uh since we said that it is a number,
the value is actually aligned aligned to
the right.
And this is a date field, which is
properly format
in standard JDBC format.
As you can see, grids provide very
flexible way of viewing the data
and uh
exporting data as well.
It is also possible to add drop-down
filters in the top here.
So, for example, you can have a
drop-down which allows you to select if
like resolved or to consult, etc.
I will talk about filters in the next
video.
All right. Thank you for watching.
Please like or subscribe.
And if you have any questions or
suggestions,
please post them to our support forum.
Thank you. Bye.