I added the below expression in Virtual Column.
Context(โViewโ) is giving blank result. I need to execute different expressions based on View.
Any suggestions would be great
Hi ,
Could you please test it in the view itself. May be with another test VC and simpler expression. In your current testing, in the test condition, is it possible that the pre-condition of view selection is not returning a status.
@Suvrutt_Gurjar : yes, Iโve tried that also. I have written simple if condition and print simple string then also itโs not working. Iโve double checked with both IF and IFS. In IFS,itโs going with true statement and for if it always went to else statement. For normal columns same expression is working. Only for VC, itโs not working.
I also printed only Context(โViewโ) in VC but it gives blank output.
Hi @rrhirani,
Thanks for update that you are using it in printing. I presume you mean printing thru workflows? I am unsure about VCs being printed based on CONTEXT () functions.
Do normal columns print based on CONTEXT () functions?
Someone else may guide you. I am sorry that I am not in front of editor currently so that I am unable to test.
@Suvrutt_Gurjar : Not exact Printing. I meant display Column string in Deck view (As secondary header) .
A virtual columnโs value is only updated/recomputed at the following times:
Thatโs it. The virtual column value is not recomputed as the user moves between views. Consequently, your expression remains what it was when the user last synced. If the row wasnโt visible during the sync, the row had no context.
Thanks @Steve for your detailed answer. So I need to create 2 VCs for 2 different equations and need to display that column in Slice. This is the only option I have right?
Iโd need to have a better understanding of what youโre trying to accomplish to provide further guidance.
@Steve : I wanted to display โ123โ for View โAโ and โ456โ for View โBโ
So I had written
IF(Context(โViewโ)=โAโ,โ123โ,โ456โ)
and It was not working it was showing 456 in both views.
So now I created two VCs and in 1st VC, I placed โ123โ and show that column in View โAโ and in 2nd VC, I placed โ456โ and show that column in View โBโ
Itโs working fine now.
@Steve : I am facing one major blocker. It will be great if you can give me some ideas regarding this issue. https://community.appsheet.com/t/new-bug-encountered-column-app-formula-working-in-editor-but-not-in...
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |