Adding row to another table as individual rows

[Badminton_Scori]

Hi

We have two table

Task table and Employee table

Employee table has a column category

I need to create several task to several people with the category

I used select statement but it’s not creating several row ,it’s showing in single row

Please help me with expression

[Marc_Dillon]

Your post is very confusing, you’ll need to elaborate.

In particular:

Badminton_Scoring:

I need to create several task to several people with the category

So your goal here is to create records in the Task Table? What else?

Badminton_Scoring:

I used select statement but it’s not creating several row ,it’s showing in single row

You used a SELECT expression, where? What was your SELECT expression? Screenshots are best. SELECT expressions by themselves do not “create” rows, so not sure what you’re saying there. And what do you mean by “it’s showing in single row”?

[Badminton_Scori]

@Marc_Dillon hi thanks for the response

I am using a action add a row in another table .

Employee table I am adding in another row in task table.

I am using select statement to one column where the category is same in Employee table.

My goal is to add multiple rows in task table

One category has different task name ,

Eg :
A catagory has 3 type of task…

If I click the action button in category table in any of the category item , automatically I need to add that 3 task has 3 individual row in task table

Please help me out…

[Steve]

https://community.appsheet.com/search?q=@steve%20%23tips%20faq%20add%20rows