Greetings,
I have 2 Tables (Assets + Check Out).
Iโve looked at some examples in the Google+ community and I created a couple actions and a workflow where, when I add a new โCheck Outโ item, It triggers an data change on the โAssetsโ Table and sets the Availability column in it to False.
I have a Company Tag column that links the tables together, but iโm not sure if my Referenced Rows Formula is correct because the value didnโt change when I tested it.
SELECT(Assets[Company Tag], [Company Tag] = [_THISROW].[Company Tag])
Any suggestions? Thanks in Advance.
I tried your Data Change workflow rule and it worked perfectly.
I updated the โCheck Outโ table record with key โ041508800600โ. When I did that the Change fired. It set field โAvailabilityโ in table โAssetsโ to โfalseโ.
I presume you must have made a change to fix the problem. At any rate, it is working now.
LOL when I first had it, the spreadsheet and app preview didnt reflect the action, so I was doubting myself.
I did make some UX changes after posting this question yesterdayโฆ
idk self-healing code.
THANKS!
It broke again after i added a couple more views.I didnt change the formula nor actions. I had it trigger upon add and updates.
Can you take a look again?
Action โCheck Out Point to Assetsโ refers to action โPoint to Assets>Availability>Set Falseโ. It appears that action โPoint to Assets>Availability>Set Falseโ has been renamed to โAvailability>Set Falseโ so the referenced action name could not be found.
If you update Action โCheck Out Point to Assetsโ to refer to โAvailability>Set Falseโ it should work again.
This uncovered an AppSheet error. We should have been validating the Composite action to ensure that the Referenced Action and Referenced Table were valid. I have added validation for this error.
If testing goes well this change will be released tomorrow afternoon Seattle time.
@Philip_Garrett_Appsh Ahhh I see! My fault, I was cleaning up some terminology and forgot to update the referenced actions.
It works again!
Thanks
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |