I don´t want Append, I want Collect

Get Help
1

Hello,

I have a collection that I can not append a New record, but I need to Collect it, even if it does not exist into the collection yet.

Any ideia ?

Thanks

2

Hi Rafa,

I am not sure I know what you mean. Could you expand by giving an example of what you would like to do.

Thanks
Craig

3

Hello,

Imagine a have a collection, and there´s no records.

In the App I have a Form with a Save Button.

The First record would be:

Product Quantity
Banana 1

If the second record be another “Banana”, should SUM the Quantitiy:

Product Quantity
Banana 2

The save button is using the comand APPEND, and in this case we will have:

Product Quantity
Banana 1
Banana 1

4

So, let me see if I have this right.

So lets pretend it is a shopping cart, you add more than one product and you want it to add up how many of the same products you have in the cart?

5

Hi,
That feature does not exist yet in Adalo, only adding new records. Depends on what you need to achieve, but one of my case scenarios what I did was:

With Zapier or Integromat

  • Create a collection to submit individual Items

  • Create a collection for Totals to do sums.

  • You add an Integromat webhook to the individual collection via custom action in the submit button

Then in Integromat/Zapier

  1. When data is received, you call the Totals collections via a GET request
  2. Use a router/filter to check if Banana already exists in the total collections.
  3. If Banana exists you will use a PUT request to update the quantity
  4. If Banana does not exist, you will create a new record in the Totals collection.
  5. Also in the end if you don’t need individual items, you can always send a DELETE request to the individual collection.
6

There are various methods that exist in Adalo to achieve this such as adding product counters which allow you to update a quantity field but unless we know what scenario you would use the function then we won’t be able to offer the best solution.

7

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.