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.
Error 400: admin_policy_enforced - HELP !!! This error came up this
morning when try to use Appsheet editor. Instructions available on Forum
are outdated and do not match the new GOOGLE Admin Console. Ther refer
to allowing Zapier as an API Trusted A...
I like to use the virtual column string from Table#1.[v_Acct_Nickname]
to as part of a column text string in Table#2. I tried the following
formulas in Table#2: Tried:
SELECT(03_Acct_List.[v_Acct_NickName],[_ComputedKey]=[_THISROW].[ID_Account])Error...
Newbee here... I posted a question a few days ago related to combining
more than one column as a key in a table. Now it is clear that when two
columns are selected as keys they form a completely new key using the
values of the two columns selected. F...
Newbee here... (May sound silly, but it is driving me up the walls...
lol) Description: Table 1 - holds the constant rate of change of a
"chemical" reaction. There are 3 standard values for each type of
reaction (Item_Rate = RateA, RateB, and RateC)....
Newbee here.. I am trying to copy a date from one table to another
using:
select(TGJobs_2020[Job_DateOpen],[Job_No]=[_THISROW].[Job_No])However,
Appsheet reports that the result of this instruction is a list. and not
the expected type "Date" Show Mor...
Marc, I am new to Appsheet - well started about 2 years ago and spent
almost a year out due to long covid (long story). so I am starting all
over again. I am using v_Acct_Nickname to add context to the KEY values
in the tables. Keys would look like X...
Marc, Thank you for your prompt response. I uploaded better images
(thank you for the heads up)I also know the column referenced has values
(I added them to the post)However, it is a virtual column (I added the
formula to the post) and I do not know ...
Gianlucapozza:This approach did not work for me.The overhead of
splitting the key and doing searches based on the parts wasover my
technical abilities in Appsheet.Let me know if you find a simpler
solution.Drop me a line if you have questions, from y...
Yes, I like to select the Rate from a Table that holds values for
several reaction rates for about 25 different materials. so the process
would be : 1) select the material. 2) select the reactionRate (RateA,
RateB or RateC). 3) enter quantity tested....
TeeSee1, Thank you for your prompt response. I tried
[Item_Amount]*[Item_Qty] and still get zero for answer... I also check
that the columns are set to Type Decimal. Any ideas?
