Hi, I have a table containing employee names and a corresponding number between 0-1. I have been trying to create an automation that will locate all names with the corresponding number 1, and create a new table with only those employees. I am having trouble figuring this out, everytime I attempt this it adds the first name in the table, whether or not their number is 1. Any help is appreciated.
Hi @Jordan_Coplan and welcome to the Coda Community!
Is it possible to share your doc with us?
Please follow this guide:
Best regards
Jannis
HI Jordan,
Welcome to the community!
Quick question before - Is there any reason you do not simply create a view and filter that view to customers = 1?
R
P
I need to be able to easily access all employees, while also having a separate table of employees = 1, so unfortunately a filter is not sufficient.
I cannot, my company has disabled the feature.
Hi @Jordan_Coplan,
okay, no problem.
There are several ways to achieve your wanted output, but I chose the method of creating a button, set the right disable if-statements and then create an automation that runs every hour and clicks the button, so the rows will be added to the new table.
Please check if that is what you visualized:
Best regards
Jannis
Hi Jannis,
This worked! However, the automation has been adding duplicate rows every hour. Is there a way to configure the automation/buttons so employees are not duplicated in the table? Thank you
Hi @Jordan_Coplan,
yes, configure the button in DB 1 so it gets disabled if the column “Added rows” is not blank.
Please let me know if you have any more questions.
Best regards
Jannis