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.
Hello, I watched the last Appsheet video about Databases and Input
functionality. The demo shows that, in the Action properties, there is
an option called "Advanced" where i can set the input values...i can't
find this option, i only have Display, Be...
Hello, I would like some clarifications about Appsheet and GDPR.As far
as i understand, Appsheet is part of Google Cloud and it does not store
any data on its cloud but it process the data. Where is the data
processed? As i am in Europe, i need to be...
Hello everyone, I have two connected tables as follows:Table one:
ID_table1, Date_t1Table two: ID_table2, ID_table1, Date_t2, x, y, zIn
table 1 i also have a column with ref_rows from table2.I would like to
make an action or automation to copy this t...
Hello, I am a new member of the community, i am sorry if this is not the
right place to ask this question. I would like to know if it is possible
to sell my apps (made with appsheet) without white labeling (or branded
app) but instead using normal in...
I am glad you solved it!Yes they are from different tables but you are
going to Group only two actions:PickARandomPerson and
SetNotAvailableFromID and they are from the same
table.SetNotavailableFromID will then call SetPersonToNotAvailable...
Hello, They actions you are going to group are from the same table:
"Random picked people", so you can group them. As far as i understood
your button (which i guess is an action) is of the Random picked people,
right? In that case you can use it
Great!! For the action part you can do the following:You already have an
action, let's call it PickARandomPersonSet an action "Set person to Not
available" for the ListOfPeople Table. The action should be "Data: Set
values of some columns in this row...
Try the following formula:index(select(ListOfPeople[ID], [Available] =
"Yes"), randbetween(1, count(select(ListOfPeople[ID], [Available] =
"Yes"))))I tested this and it works fine If you prefer, post the
structure of your tables so i can use your nom...
Ok so, I would do like this. First you need to get the random item from
the "List of people" table, I don't think you need slices, you could
work out something like this:SELECT(List of people[ID],
[Available]="Yes)This would give you a list of IDs of...
