Hello…
I’ve created resubmit button on Approval LPJ, but when push the button, the formula not worked, it’should be back to NEW status
I can’t send video format
Pleasw help mee
I think there’s some syntax errors in your formula, that the expression assistant didn’t catch, that’s causing your problems; try the following formula instead:
IF(IN(UserSettings(Divisi), list(
"Kepala Sekolah",
"Staff Keu Yay",
"Bendahara Yay",
"Ketua Yay",
"Pembina Yay"
)), "", [verify_by])
If you’re looking for a good and easy way to share screenshots (and videos), check out CloudApp - it’s what I use for all my posts here in the community. There’s a Windows app you can download that makes sharing thins SUPER easy - like ridiculously easy.
Thank you for help…
But i think, i got the problem why the formula not working…it’s because there is another formula which connect another table, hmmmm it means " CIRCULAR FORMULA"
i’have two table PCR ( Petty Cash Request ) & PCS or in Indonesia is LPJ ( Petty Cash Settlement ), in the table LPJ, there is reference column to PCR which the status lpj is OPEN
This is a very confused to explained, now i’ll try to solved it…
It’s my problem, there is Formula on Column [No Reff] which reference to another table
this formula to call transaction from another table ( PCR ) which the vc_status_lpj (type=virtual column) is OPEN,
these columns (vc_status_lpj) retrieve data from table LPJ
any idea for fixed it ?
help…
I’m sorry I’m little help here, but I’m not sure I understand what the problem is.
You might fare better with reaching out to Support@AppSheet.com, where someone can actually take a look at your app and see what’s going on.
User | Count |
---|---|
40 | |
28 | |
22 | |
20 | |
15 |