Automating settings of many rows in AppSheet with Cypress – Authentication

AppSheet AppSheet Q&A
, ,
1

Hi everyone,

I’m currently working on a prototype in AppSheet, but the business requirements are constantly changing. As a result, I frequently have to manually update translations for hundreds of data rows, which is becoming inefficient.

To automate this process, I want to use Cypress to programmatically update the “Display name” for all rows in a specific table with the following formula:

SWITCH(ANY(SELECT(Employee[Language],[Email]=USEREMAIL())),
“sk”, SELECT(Translations[sk], [key] = “<>”),
“cs”, SELECT(Translations[cs], [key] = “<>”),
“de”, SELECT(Translations[de], [key] = “<>”),
SELECT(Translations[en], [key] = “<>”)
)

I am at the beginning stage of this automation and currently struggling with setting up Cypress authentication for AppSheet under my account.

Does anyone have experience with this or any advice on how to approach authentication in Cypress for AppSheet?

Any guidance would be greatly appreciated!

Thanks in advance. :raising_hands:

Thank you.