About jfong12

jfong12 · 05-22-2023

Hi All, I know that it is possible to reference another table/row but I am not sure if it is capable of being used as strictly show or not show an entry. I have two tables: Data and Error Log, Data is the main table that holds the majority of my App ...

jfong12 · 01-10-2023

Hi Everyone,I am building automation into my AppSheet and have a button to be pressed once it meets certain criteria. I want the button to only show in certain situations, my first iteration was this:OR([Background Status]="Cleared",[Background Statu...

jfong12 · 10-14-2022

HI! I have been looking at other posts about this but haven't gotten a straight answer about it. I already added additional columns and I have a column where I want to have instructions to help the person filling out the form to locate the correction...

jfong12 · 09-01-2022

Hi Again! I had my initial question answered but I ran into another roadblock, hopefully, this is an easy fix as I am still learning App Sheet and haven't had a solution work just yet. So with the formula listed below it works but I want to include a...

jfong12 · 08-31-2022

Hi! I am using a virtual column (type - Yes/No) to show specific locations that meet two criteria: a department and a state. The end result I want is to show yes or no if it meets/doesn't meet based on the formula. I have the formula setup like this:...

jfong12 · 05-23-2023

Disregard the below reply! Your row filter worked and I was having my Error Table displaying the table instead of the error slice! Thanks for the help!

jfong12 · 05-23-2023

Sorry for the confusion!For the Column type - In Data>Columns>Error Log, I changed the Applicant ID column to ref to have a connection to the main section data. I am not sure if I am needing this still with the row filter I added to the error slice. ...

jfong12 · 05-22-2023

Yes, I do have a slice and have added your suggest row filter condition. With putting this in, I am still needing to reference the data table from the error log table, correct?

jfong12 · 09-02-2022

Thank you @dbaum! Wow, I feel silly! I was putting the parenthesis at the very end instead of right after the list for the business unit ....... excuse me as I facepalm haha

jfong12 · 09-01-2022

Hi 1minManager, I originally thought this at the beginning but I had trouble with the IF expression. I tried it again and now it works! Thank you for the help!

My Stats

jfong12's Bio

Badges jfong12 Earned

Recent Activity

Show If based on a field in a different table

Behavior - Actions - Behavior - "Only if this condition is true"

Column Description

If statement with virtual column and adding additional condition

Virtual Column not Showing

Re: Show If based on a field in a different table

Re: Show If based on a field in a different table

Re: Show If based on a field in a different table

Re: If statement with virtual column and adding additional condition

Re: Virtual Column not Showing