Custom state to save temporary inputs in a list

khalidradwan10 · 2024-08-16T08:01:25.008Z

Hi

I’m creating an invoice form where the top part is the Invoice information (customer name, address, date, etc.). The middle part is Invoice items (Description, quantity, value, Total), which is triggered when Add item is clicked. I have two database types, Invoice and Invoice items and they both reference each other.

I would like a way to save the invoice items in a custom state (invoiceItems) until the user is ready to save the full invoice, then transfer the invoiceItems to the Invoice items fields.

I wasn’t able to do this as a list. BTw: my invoiceItems custom state is of Invoice items type and it’s a list.

georgecollier · 2024-08-16T08:03:09.923Z

khalidradwan10:

I wasn’t able to do this as a list

Why not? What did you try?

boston85719 · 2024-08-16T08:11:06.740Z

khalidradwan10:

I wasn’t able to do this as a list. BTw: my invoiceItems custom state is of Invoice items type and it’s a list.

You can not make changes to the custom states values without changing the values in the database. Likely you were attempting to reference the custom state which is a list of invoiceItems and attempting to just modify the values of the invoiceItems but via the custom state value and not actually make changes to thing in the database.

khalidradwan10:

I would like a way to save the invoice items in a custom state (invoiceItems) until the user is ready to save the full invoice, then transfer the invoiceItems to the Invoice items fields.

Just use the values from the inputs within the repeating group to create the invoiceItems when the user is creating the Invoice.

khalidradwan10 · 2024-08-16T15:51:39.194Z

I tried every possible way. Please send me a step by step if you’re able to.

khalidradwan10 · 2024-08-16T15:55:57.603Z

I feel creating the invoice items before the invoice itself is cumbersome. For one, if the user creates the invoice items in the database and decides to cancel the invoice before creating, we will have to leave these items loose in the database or we need to create a workflow to delete them only if they click a cancel button. On the other hand, a list custom state that temporarily holds all this data can transfer the data only when a Save invoice button is clicked. There has to be a way out.

animisha45 · 2024-08-16T16:13:39.249Z

Manage an Invoice status. You can create an Invoice, default status - Draft. Then user can add all the Invoice Items. When finished move the status to Finalized/ Raised.

I personally do not like to use custom state for such examples because as you said

khalidradwan10:

we will have to leave these items loose in the database

boston85719 · 2024-08-16T18:29:15.129Z

khalidradwan10:

I feel creating the invoice items before the invoice itself is cumbersome.

I was unaware of the details of your setup and only assumed you had already created the invoice items and that was your custom state list value.

In terms of what you are trying to do, which is essentially creating a shopping cart, although it is called an Invoice, it is the same as an Order for a shopping cart with the invoice items basically being order line items. You can not do this with custom states well.

I just put together a shopping cart without touching database using the plugin below.

[🌟 New Features: Ultra-Deep Drill] JSON Assistant Plugin: Your Solution to Complex JSON & API Data in Bubble Plugins

JSON Assistant The JSON Assistant is a utility plugin that can be used to convert data to JSON format and extract values from JSON. The plugin is available for a one-time fee of $5 , making it an affordable and valuable addition to any developer’s toolkit. It includes two powerful elements to help you work with JSON data like a pro: Things to JSON JSON Extractor You can supercharge your Bubble app with these easy-to-use, flexible tools! Here are some use case of the JSON Assistant in app…

Please be aware, I have nothing to do with this plugin. I learned about it about 5 months ago and only today had the use case for it and it is great for this type of stuff.

NoCodeDataArtisan · 2024-08-17T17:00:58.202Z

Thank you for recommending our plugin, @boston85719.

@khalidradwan10
As Matthew pointed out, this plugin allows you to construct your database entities without committing them to the database until it’s necessary. It’s beneficial to have some understanding of JSON, but don’t worry, we’re always here to assist you with the plugin implementation.

Feel free to explore our plug-and-play application, which showcases various examples of the plugin’s use cases (JSONata Element).

Bubble

Bubble Editor - Artisan-plugnplay

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.

system · 2024-10-25T08:02:20.075Z

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