This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Need help. I have a table Person, that has a Virtual Column, of the type
“List”, called “My Providers”. The formula for the Column is:
REF_ROWS(“ClientPerson”, “Client”). It is a list of the Providers that
have that Person as a Client. The Required p...
I have a User Setting called “UserIsManager” with the expression
“IN(Useremail(),Select(Person[useremail],[Ismanager]))” So when I set a
person to a manager in there Person record, this User Setting is True. I
then filter different slices and views o...
@Aleksi_Alkio @Simon_Robinson I have just spent 4 hours, splitting my
app with the 52 tables into a smaller app, with 32 tables, many of them
read-only. The 32 table app references a spreadsheet file with each of
those 32 tables only in it. This smal...
What are the key principles when breaking a large app, with many tables,
into a set of smaller apps, with a launcher? Currently there are 50+
tables in a single Google Sheet backend, with lots of references between
tables. Should I create a set of se...
Hi folks, For some months, I have been using the CSV upload behaviour to
upload a view of a slice of data every week, into a CSV file that I then
submit to a third party organisation to recieve payment for our services
to them. I am on an Android dev...
This is VITAL and I am urgently needing this to be implemented
everywhere in appsheet. I’ve built our entire organisation on a single
Appsheet app. Starting 4 years ago when it was just me. Now there’s over
70 users. We have developers seeking to ref...
LEGEND!! I did not know that about the IFS function. That’s an awesome
bit of know-how, thanks Steve! There is no need to provide a second
outcome, and it defaults to null rather than throwing an error. Wow.
Thank you.
Hey Tsuji, NOT([Billable]) works fine, and your [Billable]=FALSE is
fine, too. The expression above works with:
ORDERBY(IF(NOT([Billable]),SELECT(PaymentRequest[ClaimReference],[ID]=“11111111”),SELECT(PaymentRequest[Claim
Reference],[ID]=[_THISROW].[...
I am having the same issue. I need to ensure that a ref column
PaymentRequest never has a value in it, when the [Billable] column is
not true. What works is to say
ORDERBY(IF(NOT([Billable]),SELECT(PaymentRequest[ClaimReference],[ID]="++++++++"),SELE...
