I want to record the column in the table using the formula I wrote below. but when I register normally, the value from the inital value does not come with the action, which is automatic, what’s the problem?
No problem when I use the formula “initial value” in the related column in the related table that is being recorded, but when I try to do it over another related table using action (using the formula below), no automatic data is coming.
this table does not come with a conditional expression initial value, even though the initial value is returned to the normal table. conditional expression not available? because when I add a record directly to the table, the initial value comes. no error in formula screen
I believe we are either not in the same page or I may expressing myself incorrectly. Can you share your app with me as a co-author? I can take a look. You can share with firstname.lastname@example.org
My application is very complicated, Data: add a new row to another table
Is there a sample formula, how to make conditional record when using?
Can ifs, if or switch formulas be used? made no errors but no results
Firstly, I’m an AppSheet Developer and Partner for over 4 years now and also having a Partner Development company which had built over 500 AppSheet apps since, I believe I have enough expertise to understand how an app is built regardless how it’s complex or not.
Secondly, I ditto that we’re still not in the same page for your problem. So I’ll try to be more refine and more clear. You have below expression:
In this expression, the fragment [ID].[Name] is called a De-Referencing Expression which denotes that in this TableA your [ID] column is a ref type to a certain TableB.
Now you are trying to create a data row with a Behaviour Action in a certain TableC and your source table is (presumably) TableA. After you have written your expression have you tested expression result in the expression builder and expanded the calculation to see which value it returns?
For sure it might have an effect on the sync time. Besides, an IFS expression shall be constructed wisely as opposed to SWITCH. By-nature, IFS expression stops evaluating the successive conditional statements once any conditional statement evaluates to TRUE. On the opposite, the SWITCH expression evaluates each one of the set conditional statements even though any one them evaluates to TRUE.