This is a special, SSW function that allows you to better automate workflow for your web applications. The function itself does not appear within Excel (i.e. =PSW_StatusIndex in a cell will not return any value). Instead, you must name the Save Cell that you would like to designate the responsible party “PSW_StatusIndex” (without the quotation marks, case-sensitive).
This function allows you to automatically set the status of a data record based on certain criteria. For example, let’s say you have a multiple tab worksheet with a layout as follows:
Let’s also say that you have created a group of statuses that goes in this order:
- Order Processing
- Order Shipping
These three tabs could be set up with permissions such that the person filling out the form does not see the latter two tabs. On each page, you could also set up a function that checks certain cells for input. If cells C4:C10 are all necessary inputs on the “Order” page, you would set an equation (let’s say in cell D15) to check these cells and if they are all filled out at the time of submission (the output value would either be TRUE or FALSE, 1 or 0). Then, you could set up a data table, similar to the one explained in the PSW_UserName section. Again, you could use a VLOOKUP equation so that when cell D15 = 0, the recalled value is 0 (Incomplete) and when D15 = 1, the recalled value is 1 (Order Processing). Note: The statuses are given values ranging from zero to however many statuses you have created. The first status is 0 and all subsequent statuses are given numerical values in order. In this case, Incomplete would be associated with 0, Order Processing with 1 and so on.
Then, all you have to do to set the order status to automatically change in respect to cell D15 is name the column identifier for that save cell in the SSW Wizard to “PSW_StatusIndex”. Note: The function is case sensitive and should be entered without the quotation marks.