I have two main sources, a company table and database. I have created an action โusing the Add a new row to another table using values from this row." to transfer companies from the table to the db if the Transfer status of the company is True (Checkbox).
I need to add a check between the two tables to make sure that a row doesn't get copied twice with two different unique IDs.
When a company is added to the DB then it gets another Unique ID (PID#), I need to add a check if the company already has a PID# before trying to add it.
Also, if possible, I would like it to update rows between the two tables if it already exists.
Using this QA Response , which I think is part of what I'm trying to achieve, I used the expression below in the actions behavior area, but got this error " The expression is valid but its result type 'List' is not one of the expected types: Yes/No".
So, not sure where to put this exactly, if this is what I need to do.
SELECT(
DA_RAW[InfoGroup ID#],
AND(
([Transferred] = [_THISROW].[Transferred]),
(
[_ROWNUMBER]
= MIN(
SELECT(
DA_RAW[_ROWNUMBER],
AND(
([Transferred] = [_THISROW-1].[Transferred]),
([PID#] = [_THISROW-1].[PID#])
)
)
)
)
)
)
Any help or direction is greatly appreciated.
As the error message says, SELECT returns a list but you need an expression that returns a yes\no valu.
You may want to enclose the SELECT with ISBLANK or ISNOTBLANK (I have not checked your logic so you may need yet another function that returns a yes/no)
So far it looks like that the Appsheet databases can't reference appsheet tables to make this verification happen. I can only move data between the two, with the action I already created.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |