Automate Action

[AbdullaNsour]

Hi all, I have an AppSheet project with the following tables:

1. Table: Course

   Columns:

   • C_ID
   • Male count
   • Female count
   • Total

2. Table: Student

   • Columns:
     • S_ID
     • Sex
     • Course

The Course column in the Student table is a Ref to the Course table.

---

I created an action in the Course table to calculate the total number of students using this expression:

Count(Select(Student[ID-NNI], AND([Sex]=“M”, [Acteurs]=[_THISROW].[Specialize_ID]))) + Count(Select(Student[ID-NNI], AND([Sex]=“F”, [Acteurs]=[_THISROW].[Specialize_ID])))

Now, I want to automate this action in the Course view using Automation in AppSheet:

• Process: Run Data Action / Run Action on Rows
• Referenced Table: Course

What expression should I use in Referenced rows to ensure the action runs correctly?

Next I need to calc the Rate of Male and Female but it’s not changed !
I try to create the action for this matter & it’s work correctly but when I run it thru Automation it’s not work

[yasarcan]

Hi

Oranları oluşturan formülleri ve aksiyonları ayırın.

Erkek oranı: [Male Count] / [Total] * 100

Kadın oranı: [Female Count] / [Total] * 100

Grup aksiyonu hazırlarken ilk olarak öğrenci sayılarını güncelleyen aksiyon çalıştırılmalı. Daha sonra erkek / kadın oranlarını hesaplayan aksiyonu çalıştırın.

[AbdullaNsour]

Yes, I set it up, but the issue was with the column types. The [Male Count] and [Female Count] columns were set to Number, while the [Rate Column] was set to Decimal, which caused it not to work.