# How to transform data into database

**URL:** <https://forum.adalo.com/t/how-to-transform-data-into-database/1631>\
**Category:** Get Help\
**Created:** [May 31, 2020, 4:04am UTC](https://forum.adalo.com/t/how-to-transform-data-into-database/1631 "2020-05-31T04:04:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![silvaa10](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@silvaa10](https://forum.adalo.com/u/silvaa10)\
**Post date:** [May 31, 2020, 4:04am UTC](https://forum.adalo.com/t/how-to-transform-data-into-database/1631/1 "2020-05-31T04:04:15Z")

</div>

hello

I assembled some information (ingredients, quantity and costs). The cost is multiplied by the quantity and value of the ingredient (both are already in the database). But I would like all this information after filling in to become a database. Is there a possibility to do the reverse? from the data build up the database? Rather than creating the bank first? Because I only found Adalo forms to do this but it does not meet my project.

 ![Captura de Tela 2020-05-31 às 01.03.25](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/1X/6bb582c70f607b8dd64f628b6f7ab33d98719f1e.png)

---

<div class="post-metadata">

**Author:** ![projectlinuxsupports](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/projectlinuxsupports/32/1023_2.png) [@projectlinuxsupports](https://forum.adalo.com/u/projectlinuxsupports)\
**Post date:** [June 1, 2020, 10:48am UTC](https://forum.adalo.com/t/how-to-transform-data-into-database/1631/2 "2020-06-01T10:48:15Z")

</div>

A trick come to my mind that maybe you can try.

For example you build 2 Collection :

1. Databases

- Name
- Ingredient (relation to Ingredients Collection)

1. Ingredients

- Ingredients
- quantity
- Costs
- Database (relation to Databases collection)

Everytime you create a new Information that want to link to a new database, just create an action that create new Database and create a new Ingredients, then change the relation to the newly created database.

For example :

First you have these data :

Ingredients A

- Ingredients 1
- Quantity 1
- Costs 1
- Relation to Database A (Databases collection)

Then when you change the value of the ingredient, add actions :

- Create Database B
- Create new Ingredients (using value from the input), then assign the Database relationship to Database B.

So you have these records now :

Databases Collection

- Database A | linked to Ingredients 1
- Database B | linked to Ingredients 2

Ingredients Collection

- Ingredients 1 | Quantity 1 | Cost 1 | linked to Database A
- Ingredients 2 | Quantity 2 | Cost 2 | linked to Database B