Link in E-Mail to fire an Action
Is it possible to include a Link in an E-Mail Workflow Template that fires an Action? Right now I include a Link that opens the Detail View of a row and the user can click on the Action โcompletedโ. But I would like to fire the Action right out of the E-Mail, so that the user does not have to open the App.
You can set a datetime column in your sheet and record NOW() value in that column for a particular row with AppSheet API which will also triggee that action button.
@Levent_KULACOGLU Could you explain a little bit more please? Iโm sorry, but I donโt understand.
{
โActionโ: โEditโ,
โPropertiesโ: {
โLocaleโ: โen-AUโ,
โLocationโ: โ47.623098, -122.330184โ,
โTimezoneโ: โAUS Eastern Standard Timeโ,
โRunAsUserEmailโ: โesosurveyors.com.au@gmail.comโ
},
โRowsโ: [
{
โLine #โ: โ<<[Line #]>>โ,
โDATE REPORTED TO PAYROLLโ: โ<<CONCATENATE(INDEX(LIST(โSunโ, โMonโ, โTueโ, โWedโ, โThuโ, โFriโ, โSatโ), WEEKDAY(DATE(NOW()))),โ โ,if(len(concatenate(DAY(NOW()),โ"))=1,โ0โ,""),DAY(NOW()),"/",if(len(concatenate(MONTH(NOW()),""))=1,โ0โ,""),MONTH(NOW()),"/",YEAR(NOW())," โ,concatenate(if(len(concatenate(HOUR(TIME(NOW())-โ00:00:00โ),โ"))=1,โ0โ,""),HOUR(TIME(NOW())-โ00:00:00โ)),":",concatenate(if(len(concatenate(MINUTE(TIME(NOW())-โ00:00:00โ),""))=1,โ0โ,""),MINUTE(TIME(NOW())-โ00:00:00โ)))>>"
},
]
}
==========================================]
according to the article i have to say this instead:
โActionโ: โEXECUTE CLIENT APPROVE ACTION SEQUENCEโ,
what i cannot work out is:
where do i configure in the APP
the reaction Webhook JSON body
to an email recipient clicking the above link?
and
the link specified Slice HRF16%20WEEKLY%20WEDNESDAY%200h%20TO%20TUESDAY%2024h selects the correct rows,
and โActionโ: โEXECUTE CLIENT APPROVE ACTION SEQUENCEโ, specified the actions and columns i want changed,
so:
what is the correct โRowsโ statements i need to make?
thanks, Team.
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |