I have read a lot, but can't figure this out. If I have:
How can I use the form from table 2 to update records in table 1? Here are my tables:
I've got the app set up how I want it:
But I can't seem to make the actions and connections necessary so that:
This video got me close, but I couldn't get it to work. Can anyone explain how to do this? TIA
Solved! Go to Solution.
I appreciate the nudges. I went back and rewatched a video or two, read a bunch more documentation, and then was finally able to figure this out using the LOOKUP() and SELECT() functions/expressions. The steps for doing this, I think, are fairly complicated, so I recorded a video that should help anyone else who encounters this challenge.
Ohne Ihre Aktionen zu kennen, kann man schlecht Lรถsungen finden. Folgendes wรคre eine Lรถsung nach der Frage:
Daten: Fรผhren Sie eine Aktion fรผr eine Reihe von Zeilen aus Action 1
Aktionsname | Maรnahme 1 |
Fรผr eine Aufzeichnung dieser Tabelle | Eingabetabelle |
Mach das | Daten: Fรผhren Sie eine Aktion fรผr eine Reihe von Zeilen aus |
Referenzierte Tabelle | Ausgabetabelle |
Referenzierte Zeilen | FILTER( "TABELLENNAME",[Spalte]= [_THISROW]. [Spalte) |
Referenzierte Aktion | Nach Eingabe der Action 2 diese Action 2 auswรคhlen!! |
Verhalten | |
Nur wenn diese Bedingung wahr ist | Kรถnnte sein! [Statusspalte] = "Komplett" |
Wirkung: Daten: Legen Sie die Werte einiger Spalten in dieser Zeile fest Action 2
Aktionsname | Maรnahme 2 |
Fรผr eine Aufzeichnung dieser Tabelle | Ausgabetabelle |
Mach das | Daten: Legen Sie die Werte einiger Spalten in dieser Zeile fest |
Legen Sie diese Spalten fest Zu den definierten Konstanten- oder Ausdruckswerten | Kรถnnte sein! Erledigt?="Ja" โ |
Verhalten | |
Nur wenn diese Bedingung wahr ist | STIMMT |
Vergessen Sie nicht, im Editor unter Ansichten Ihrer "Eingabetabelle" das Verhalten festzulegen!!
Formular gespeichert | Maรnahme 1 |
Thanks for your help. I've tried something similar but I can't get it to work. Here's what I've tried:
For the first action:
Action name | Action1 |
For a record of this table | UpdatesList |
Do this | Data: execute an action on a set of rows |
Referenced Table | Record |
Referenced Rows | = FILTER("Record",[Changed?]=[_THISROW].[New favorite fruit]) |
Referenced Action | Action2 |
Prominence | Do not display |
Note: I'm probably having the most trouble with the Referenced Rows part. I'm just trying to change "Favorite fruit" to whatever the new favorite fruit which was selected when the UpdatesList form was filled out, and also "Changed?" to "Yes".
For the second action:
Action name | Action2 |
For a record of this table | Record |
Do this | Data: set the values of some columns in this row |
Set these columns | Changed? = "Yes" |
Prominence | Do no display |
In the view for UpdatesList under Behavior I have this:
Event Actions | Row Selected: Action1 |
Is there something obvious I'm doing wrong? I'm clearly getting something mixed up, but I can't figure out what. Thanks in advance for any further help you can provide.
Das sieht eigentlich gut aus, nur der Filterausdruck sollte so lauten:
FILTER("Record",[Person] =[_THISROW].[Person who favorit])
Haben Sie in Ihrer Ansicht Formular "Updates-Liste" das Verhalten festgelegt?
Formular gespeichert | Maรnahme 1 |
I appreciate the nudges. I went back and rewatched a video or two, read a bunch more documentation, and then was finally able to figure this out using the LOOKUP() and SELECT() functions/expressions. The steps for doing this, I think, are fairly complicated, so I recorded a video that should help anyone else who encounters this challenge.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |