How to create data with repeating group without using auto-binding method?

yuehong · 2024-11-06T14:14:10.799Z

I have a database structure that looks like this:

Invoice

Invoice No: text
Customer Name: customer
Date: date
Total: number

Invoice Item

Item Name: item
Detail: text
Quantity: number
Unit Price: number
Subtotal: number
Invoice: Invoice

The layout for the create page looks something like this:

Screenshot 2024-11-06 at 22-10-47 Yuehong Bubble Editor888×614 9.52 KB

Each invoice can have multiple invoice items.

Currently, when the create form page is loaded, it directly creates a new invoice and invoice item record in the database. We enable auto-binding for each input field in the repeating group. However, this creates a problem where a new database record is created every time the page is loaded. How can I create and save repeating group data without using the auto-binding method and only create the database record once the user clicks the “Create Invoice” button?

jonathan.hernandez · 2024-11-08T13:48:53.165Z

Hey @yuehong

On Invoice Data Type, they can create a new field something like: Is Invoice Final = Yes/No. The default value is: No.
On invoice-page load, They can add a condition on the Create Invoice Workflow(Only when Do a Search From Invoice Where Is Invoice Final = No).
When Loading the Invoice Details:
They will only load the Invoice created by the current user where Is Invoice Final = No
When the user clicked on the “Create Invoice” button, they can Add a workflow to update the Invoice created by the current user where Is Invoice Final = No into “YES”

mustafamteck · 2024-11-08T14:14:45.196Z

Hey, hoping that you all are doing well.
Can you please tell me how can I prevent new invoice records from being created on page load and only finalize the invoice record once the create invoice button is clicked?

gloriaui · 2024-11-08T14:31:37.114Z

yuehong:

We enable auto-binding for each input field in the repeating group.

First, you must disable auto-binding.

When you click on the create invoice button, you create a new invoice in the database. - “Create a new thing” of the Invoice Item type, with all its fields.

In a second workflow, you must change - “Make change to thing” the result of step 1, linking this invoice item created with the other table of the Invoice type.

I hope this was clear to you and that it may have helped you in some way.

yuehong · 2024-11-09T02:06:40.934Z

gloriaui:

In a second workflow, you must change - “Make change to thing” the result of step 1, linking this invoice item created with the other table of the Invoice type.

Thank you for your answer. Could you please explain in detail how to save and create repeating group data without using the auto-binding method? I’m not sure how this part works.

hanan1 · 2024-11-09T05:01:45.465Z

I would create each invoice item and leave the invoice field empty in the beginning, they will still be saved to the database, and
add them a to a list custom state to save some work finding them later.
when user clicks the button to create invoice, create a new thing (invoice) and then make changes to list of things (the custom state’s list) where invoice = result of step 1 (create invoice).

system · 2025-01-15T14:14:36.327Z

This topic was automatically closed after 70 days. New replies are no longer allowed.