Hello, I’m trying to develop a function/form (I’m not sure) that allows you to select several items from the stock and add the lines ‘Customer Name’ and ‘Phone’.
Each stock item has a UNIQUEID(), so when selecting the product name, I need it to list the UNIQUEID’S so I can select which ones will be sold to Customer X (open/additional field)
Your exact requirement is not clear. But it sounds that the Order Capture sample app could help you at least as a reference. In the app, the user can create an order on a customer and add multiple products from the products table as order details to each order.
Order Capture How-to - AppSheet
Help article on the list of sample apps:
Hello friend, thank you for your accurate and prompt attention. Exactly what I was looking for, however I’m facing some errors.
First, I couldn’t copy the app because the “Order Details” data table is not accessible.
Second, the column “Total Cost” of the table “Orders” has in ‘Spreadsheet formula’ = ‘SUMIF(‘Order Details’!B:B,RC[-5],‘Order Details’!E:E)’, which I don’t know what it is because I can’t access the table data.
and the main one, in the ‘Order Capture How-to’ application in View:
‘Open Orders_Form’
Table:
‘Open Orders’, the virtual column ‘Open Order Details’ has the ‘Show’ option unchecked but this table only appears for me if it has ‘Show’ checked.
Anyway, if you could release the application, it would help a lot. I’m still lost
Hi @ecosolux ,
I do not own that app. It is a standard sample app available in AppSheet repository and listed in a help article of feature sample apps. I have already shared the article with you.
Maybe you are not using the “Copy App” option shown in the image below to copy the app.
Also after copying the app, you will most likely get the error under security options. Please uncheck (Switching it off) the option of “Allow all signed-in users” and retain the option “Require user signin ?” by checking it (switching it on) .
Thereafter you should be able to use the app copied by you.
if you still face any issues in sample app copying procedure, I request you to take help of the AppSheet support team.
Thank you, the copy of the app was successful. I don’t understand this ‘,RC[-5]’ part of the function (SUMIF(‘Order Details’!B:B,RC[-5],‘Order Details’!E:E)
Please take a look a the following article on R1C1 notations in Google sheets and help article of AppSheet.
Understood.
Another doubt, the application points to an aggregated group ‘SUM:: Total Cost’ which is not available in my application. Is there a way I can create an aggregated group?
