Action and Expression

AppSheet AppSheet Q&A
1

Hello again,
this is for weekly payroll.
from the dynamic list of Names in my parent table, i am trying to combine all the names in 3 different employee role columns and then pick up the name that hasn’t been captured yet to put in the payroll table.
my plan is to create an action that will automatically compute all the pay for each name. the payroll table has a spreadsheet formula that will compute all once name is dropped in name column.
so far this expression is giving me one name continuously . How can I get an action to fill all the name in payroll table, either in single or bulk action?

 (Dipstick[Pump 1 Attendant]
            +
 Dipstick[Pump 2 Attendant]
             +
   Dipstick[Cashier])
            -

Select(Salary[Name],[Week]=[_Thisrow].[Week])

3X_f_d_fd7cf925189da055ea12e845914a236267cf8f67.png
3X_f_d_fd7cf925189da055ea12e845914a236267cf8f67.png535×253 3.61 KB

3X_5_1_51709e65ed7783a5979800065c6275b0af711780.png
3X_5_1_51709e65ed7783a5979800065c6275b0af711780.png1503×399 10 KB

2

Do you have this Payroll table imported to your app?

3

yes LeventK

4

Firstly you need to ensure that, all columns except the ones that will be filled by action does not contain any formula in the Spreadsheet formula property of each column’s column structure. Then check out these posts:

[FAQ: Add a number of rows](https://community.appsheet.com/t/faq-add-a-number-of-rows/30503) Tips & Tricks ?

Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: Finish Count (…

[Add any number of rows from any row within a table](https://community.appsheet.com/t/add-any-number-of-rows-from-any-row-within-a-table/22869) Tips & Tricks ?

Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possible, but it’s not easy. This article details an approach that can be accomplished entirely within AppSheet (no API use), within the app itself (no workflow use), and accommodates an arbitrary number of rows (no built-in count maximum). While I’ve tried to make the guide accessible for less-experienced app creators, make no mistake: this is an advanced technique. I hope you find this us…

2 Likes