About FTong

FTong · 03-16-2023

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...

FTong · 02-08-2023

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...

FTong · 03-06-2022

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...

FTong · 03-06-2022

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)....

FTong · 03-06-2022

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...

FTong · 02-08-2023

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...

FTong · 02-08-2023

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 ...

FTong · 08-17-2022

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...

FTong · 03-06-2022

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....

FTong · 03-06-2022

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?

My Stats

FTong's Bio

Badges FTong Earned

Recent Activity

Error 400: admin_policy_enforced - HELP !!!

Unable to find table '03_Acct_List.', did you mean '03_Acct_List'?

Is there a way to reference table rows when a using a combined key.

How do you multiply two numbers in Appsheet?

What is the proper way to copy dates from one table to another?

Re: Unable to find table '03_Acct_List.', did you mean '03_Acct_List'?

Re: Unable to find table '03_Acct_List.', did you mean '03_Acct_List'?

Re: Is there a way to reference table rows when a using a combined key.

Re: Is there a way to reference table rows when a using a combined key.

Re: How do you multiply two numbers in Appsheet?