Help with formula

AppSheet AppSheet Q&A
, ,
1

Hi! Basically i m trying to do a app for myself to use in my job.

I able to do a stock, and in a slice i can see all the items that i need to order.

I also add a automation that with a botton i can send a Whatsapp to a number of the suppliers.

The problem its that when i got the list of items , i can send a Whatsapp only one by one and i would like to be able to send a unique WhatsApp for each supplier.

The columns that i got are:

Product , min.Stock , in.Stock ,Quantity to order, Supplier, phone number Supplier,

The formula that i use for WhatsApp is:

CONCATENATE(“https://api.whatsapp.com/send?phone=“,CONCATENATE(”+34”,[phone number Supplier]),“&text=”,CONCATENATE("Hi! I would like to order: " , [Quantity to order], " " , [Product]))

So.. there is any way , that will make me able to group all the products by supplier by changing this formula?

2

Here is one way you could do this (I am sure there are other ways)..

  • Create a virtual in STOCK table with an expression [Quantity to order] & ": " & [Product]
  • Create an automation on SUPPLIERS table to send WhatsApp api requests in which a list of Quantity/Product can be retrieved by [Related STOCKs][VC previously created]
2 Likes
3

As @TeeSee1 implies, your first step may need to be to create a separate Suppliers table if you don’t already have one. Then, reference a supplier row from each row in your existing table to associate a product with its supplier. Create the automation (or, perhaps what you really have is an External: go to a website action, which is not an automation) from the Suppliers table.

1 Like