Issue with Duplicate Actions and Unrecognized Actions in AppSheet

[ilanbo]

Hello AppSheet Community,

I’m encountering some issues with actions in my AppSheet application, and I hope someone can provide guidance on resolving them. Here is a detailed description of my setup and the problems I’m facing.

Application Setup

I have two main tables: Attività (Activities) and Clienti (Clients).

• Clienti Table:
• IdCliente (Key)
• Nome
• Cognome
• Mail
• Telefono
• Attività Table:
• IdAttività (Key)
• Tipo attività (Type of Activity)
• Data e ora (Date and Time)
• Descrizione (Description)
• IdCliente (Ref to Clients)
• Telefono
• Mail

Objective

1. Verify Client:
• Check if the client exists in the Clienti table using the Telefono or Mail from the Attività table.
• If the client doesn’t exist, add a new client to the Clienti table.
2. Register Message:
• Once the client is verified or added, create a new activity in the Attività table with details from the WhatsApp message or email.

Actions Created

1. Verify Client:
• Type: Data: execute an action on a set of rows
• Referenced Table: Clienti
• Referenced Rows: SELECT(Clienti[IdCliente], OR([Telefono] = [_THISROW].[Telefono], [Mail] = [_THISROW].[Mail]))
• Referenced Action: Verifica e crea cliente
2. Register Message:
• Type: Data: set the values of some columns in this row
• Set Columns:
• IdCliente = ANY(SELECT(Clienti[IdCliente], OR([Telefono] = [_THISROW].[Telefono], [Mail] = [_THISROW].[Mail])))
• Descrizione = "Rispondere a " & [Tipo attività]
• Scadenza = NOW()

Problems Encountered

1. Duplicate Actions:
• When I create an action, AppSheet sometimes creates a duplicate action with a suffix -1 (e.g., Registra messaggio Action - 1). These duplicate actions are not visible in the main action list but appear in the process configuration.
2. Unrecognized Actions in Processes:
• When configuring the process, the custom actions I’ve created are not recognized. The process fails with errors like:
• The data action ‘Registra messaggio Action - 1’ does not define a valid expression for reference rows. This expression must compute a list of Ref values.

Steps Taken

1. I ensured the action settings are correct and set to be visible.
2. I matched the table settings between the actions and the process steps.
3. I tried refreshing the AppSheet interface and recreating the actions and processes from scratch.

Despite these efforts, the issues persist, and I’m unable to achieve the desired functionality. Any insights or suggestions to resolve these problems would be greatly appreciated.

Thank you in advance for your assistance!