LinkedIn
Twitter
Hi all,
I'm setting a Bot, this morning everything run fine, but at this afternoon, I got the below issue
Below is Event condition expression, it results in some Y (True) result
In the Process, I set a Branch condition with the same formula as Event's, but I don't know why it's only running to the branch's No (False) result
I've been checking this for hours but still don't know how to fix it
Could I ask some Appsheet's professional to check inside my account ? My ID is : 2730282
My REQUEST table :
| STT | ID | CREATE DATE | COMPLETE DATE | TYPE | STATUS | SUPPLIER ID | ORDER | REQUEST # | BRAND | REQUEST DATE | REQUEST ETD | REQUEST NOTE | SHIP MODE | PAYMENT | UPDATE | TIMESTAMP |
| FALSE | 5a46190b | 4/26/2022 | ORDER | Open | 44 | MST-21-08 | b | MST | 4/24/2022 | 5/26/2022 | By Air | T/T | 5/4/2022 16:21:20 | 20220504_162424 | ||
| FALSE | a362f4c2 | 4/26/2022 | ORDER | Open | 41 | MST-21-08 | c | MST | 4/24/2022 | 5/30/2022 | By Sea | T/T | 5/4/2022 16:21:20 | 20220504_162424 |
My MATL REQUEST table :
| ID | CREATE DATE | COMPLETE DATE | TYPE | STT | STATUS | SEND EMAIL | TRACK | ORDER | REQUEST # | BRAND | REQUEST DATE | REQUEST ETD | REQUEST NOTE | MATL ID | SUPPLIER ID | SUPPLIER | COUNTRY | ITEM NAME | SPEC | COLOR | UNIT | CODE | PRICE | NOTE | QTY | RECEIVED | RECEIVED DATE | BALANCE | USE | REMAIN | UPDATE |
| 2 | 4/22/2022 | 5/4/2022 | ORDER | FALSE | Open | TRUE | MST-21-08 | 5a46190b | MST | 4/24/2022 | 5/26/2022 | 19 | 44 | CHUNGA LABEL | KOR | WAIST BELT SIZE TAG XS/S 26-32 in (66-81 cm) | 25X50MM | BLACK / WHITE | PC | $0.0500 | MOQ 5,000pcs | 10 | 0 | 4/28/2022 | 10 | 0 | 5/4/2022 16:00:02 | ||||
| 8929df98 | 4/24/2022 | ORDER | FALSE | Open | TRUE | MST-21-08 | a362f4c2 | MST | 4/24/2022 | 5/30/2022 | 60 | 41 | COMBINE PRODUCT INTERNATIONAL | HK | SPADE ATTACH FIRE HANG TAG | MEDIUM | PC | $0.0870 | 10 | 10 | 4/28/2022 | 0 | 10 | 0 | 5/4/2022 16:00:02 | ||||||
| a7722cea | 4/26/2022 | ORDER | FALSE | Open | TRUE | MST-21-08 | a362f4c2 | MST | 4/24/2022 | 5/30/2022 | 39 | 41 | COMBINE PRODUCT INTERNATIONAL | HK | EXPEDITION FEATURE HANG TAG | LARGE | PC | $0.0920 | 10 | 10 | 4/28/2022 | 0 | 10 | 0 | 5/4/2022 16:00:02 | ||||||
| 9fe3e4fc | 4/27/2022 | ORDER | FALSE | Open | TRUE | MST-21-08 | a362f4c2 | MST | 4/24/2022 | 5/30/2022 | 40 | 41 | COMBINE PRODUCT INTERNATIONAL | HK | FIRE BACK HANG TAG | MEDIUM | PC | $0.1520 | 500 | 500 | 5/4/2022 | 0 | 500 | 0 | 5/4/2022 16:00:02 | ||||||
| 3a3a1837 | 4/27/2022 | 5/4/2022 | ORDER | FALSE | Open | TRUE | MST-21-08 | a362f4c2 | MST | 4/24/2022 | 5/30/2022 | 41 | 41 | COMBINE PRODUCT INTERNATIONAL | HK | FIRE FRONT HANG TAG | MEDIUM | PC | $0.1450 | 30 | 30 | 0 | 5/4/2022 16:00:02 |
Solved
1 ACCEPTED SOLUTION
I figured it out, very happy, even just by guessing and trial and errors : D
When I put the column STT as column A in spreadsheet, it doesn't work ( even the key column is the column ID )
When I move the column key ID to the column A, it works !, not sure why
I check the below expression result, they are 1 and 4, must > 0 and yield True (YES), but not sure why it's following the False (NO) branch
COUNT(SELECT(MATL REQUEST[ID], AND([TYPE]="ORDER", [REQUEST #] = [_THISROW].[ID],[SEND EMAIL] = TRUE,[STT] = FALSE,[STATUS]="Open", ISBLANK([TRACK]) )))
I also tested by an task before the branch, the result yielded as TRUE, not know why it's following FALSE branch
