Re: Prefilled google Form based on Column value

Akshay1 · 12-18-2020 04:16 AM

Hi Team,

I am trying to create an app, where once the order is placed, it reflect in the app as order status “New”, the our warehouse team do the picking activity after which they update the order status as “Picked”, once the mark order status as “picked”, Our QC team has to do the Quality check of the order to finish the Quality check they have to fill the Separate prefilled Google form where they have to update some fields .

How I can Achieve this, A prefilled form to popup for every individual order when the user change the Status on an order to completed.

MultiTech

Hello @Akshay, and welcome.

Have you checked out the Sample Apps provided by AppSheet? They have an order capture sample that might contain some elements you could use:

https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=245...

A typical thing I would do in this scenario is to create an [Order_Status] column; with this you can set the initial value to whatever your starting status value is (New) and then use Actions to change that value later on.

Akshay1

Thank you for the response.

Please check below image for more clarification.

As, you can see in the below image, Basically when the status of an order is changed to “packed” a pre-filled google form link gets update in the form column, which contains the respective “order id” of that order against which the status is changed to “Packed”.

I want the same thing to be happen in my app, also form should open within the app itself so that i can use “scan” option to fill the required details (barcode) which needs to be updated