Zeroqode Plugin Bubble page to PDF Converter Make change in database

douzaines.polder-0v · 2024-11-07T15:37:18.171Z

Hello,

For your information:

I have an RG table containing invoices, for invoice 1, I would like to attach its single “Proforma”, its single “Acompte” payment invoice and its single “Facture”.

I’ve created a "ConverttoPDF “proforma” Uploading to AWS is finished event and a create a new “DB_Facturation_File” step, which is where I store all my proforma urls. This step is ok and fine ( no problem!)

> But now, I’d like to change an entry in my “DB_Facturation” database ( to display the proforma url dedicated to this “FichierProformaPDF”, idem for "Acompte and “Facture”.
> I’ve tested a make change but it only changes one entry → it doesn’t work.

Can someone from the @ZeroqodeTeam or anyone els here in the chat help me?
Thank you!

SCR-20241107-ofpy2794×688 71.8 KB

SCR-20241107-ofys2758×738 219 KB

SCR-20241107-oglc2601×1060 170 KB

SCR-20241107-ohhq2544×888 173 KB

SCR-20241107-ohwi2102×1200 157 KB

SCR-20241107-oieh2268×1428 133 KB

ZeroqodeSupport · 2024-11-11T11:12:35.495Z

Hello @douzaines.polder-0v,

From your message, it appears that you have successfully saved the PDF in your data table. However, it’s not entirely clear what you intend to do afterward.

In the first step, when you save the video, you’re storing it in the “Proforma” field of the DB_Facturation_Fichier table. If you want to save the file in other tables as well, you can either use the same element state in the workflow as in the first case or save the file in a state within your app for later use.

To better understand how databases work in Bubble, please refer to the Bubble manual: The database | Bubble Docs

Thank you for your understanding. Have a great week ahead!

Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble

douzaines.polder-0v · 2024-11-11T13:45:08.814Z

Dear,

Yes, as I said and showed in the attachments and as you understood, the file is saved in the DB_Facturation_Fichiers database. I marked it in green in the attached file in this forum -->I write in green color–> it’s OK.

I know how database work in Bubble…

*My request is that I want to be able to add the proforma, account invoice and invoice file in an existing line of my DB_Facturation database. ** So I supose that I need to make a make change in the database, but it doesn’t work. As I marked in the attachment NOT OK in red color!!!

So how to add this PDF file in an existing line of DB_facturation??? I don’t want to make a “create database”, because I don’t want it to create a new line.

ZeroqodeSupport · 2024-11-12T14:56:43.184Z

Hi @douzaines.polder-0v,

Thank you for your reply.
Hope we got it right.

Your question is related to how Bubble saves things into the database, to find more about this, we strongly recommend checking the Bubble manual or Bubble tutorials: Data (things) | Bubble Docs

Here are some general recommendations:

To update an existing record in your DB_Facturation database with the new PDF file, you don’t need to create a new entry. Instead, you can use a Bubble workflow to “Make changes to a thing.” Here’s how to set it up:

Set Up the Workflow Action:
- In your workflow, add an action that specifically targets the existing entry in DB_Facturation.
- Select “Make changes to a thing” rather than “Create a new thing.”
Identify the Record to Update:
- In the “Thing to change” field, specify the record you want to update. This could be based on a unique identifier or search criteria that selects the correct line in your database.
- For example, if you have an ID or any other unique field for the existing line, use a search to identify this entry.
Update the PDF Field:
- Once the record is identified, set the field for the PDF file (e.g., invoice_file or proforma_file) to the new PDF file you’ve generated.
Check the Workflow and Database Constraints:
- Ensure that no constraints are preventing the update, such as field types or privacy rules in Bubble that restrict updates to certain fields.

This approach should allow you to add the PDF to an existing line in DB_Facturation without creating a new entry.

Hope it helps.

In case you are looking for a Bubble developer who can assist you with these customizations with your Bubble app, can try searching for it in the Help Section on the Bubble forum or hire a freelancer.

Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble