@praveen - I just thought I should share my “day in the life” learning Appsheet…
Cool. I see more posts on the community. Some wise people are sharing their knowledge to help real users like me! @LeventK just responded to a user yesterday with advice how to handle “cascading” input forms, were one form leads directly to another! Never thought about more than one “hop”, so I start reading…
@LeventK posted a LINKTOFORM formula to use in each form that looked like this:
LINKTOFORM(“Chainsaw002_Form”, “ID”, UNIQUEID(), “Hardware”, [MaxRowColumnName].[Hardware])
I take a look and start wondering… what is the “.” for in the [MaxRowColumnName].[Hardware] section?
So I go to the support pages and check LINKTOVIEW and see the following syntax:
LINKTOFORM(view-name[, column-name, column-value]…[, app-id])
So I decide to check in an appsheet editor field and see if the examples help. In the equation editor I get:
LINKTOFORM(form-view-name, [column-name1, column-value1, column-name2, column-value2, …], [app-id: TEXT])
with an example of:
LINKTOFORM(“Some Form View”, “Date”, TODAY(), “Color”, [_THISROW].[Color])
This seems a bit more clear. The editor is suggesting column name / value pairs in brackets. Ok. And LOOK! There is the “.” showing up in the example [_THISROW].[Color]. But… I am still not sure what it is for.
I assume [Color] is a column in the _THISROW row, but THISROW is not a column and its surrounded by braces too. So… is [Color] a column in THISROW which is not a column?
I also see a formula TODAY() in this example and the syntax suggests that’s not a column value as its not surrounded by braces, but there is also “Date” in quotes and no brackets. What the heck is all of that? When do I use braces and when do I use quotes?
So now I am even more confused and frustrated. Sometimes we use brackets for columns, but maybe values too? And when is "Color" not a [Color]? And finally, I still have no idea what the "." is for! The only thing I think that is clear is, the guy asking the question wants to track chainsaws!
(thought to self - this platform is much harder to learn than I realized. I just can’t seem to get a handle on the “language” they are using, and looking at examples to figure out how “.” is used takes way too much time. In fact, the examples are great, but to figure out my specific use case I need to first understand someone else’s table/view/column/formula setup, just so I can figure out how to use “.” properly. maybe I should find a programmer after all…).
This might just be my brain not working that well (and you could argue my IQ is too low as well), but this if my real-life experience with learning appsheet. To be clear - I really love this platform, and the team behind it is off-the-charts awesome!!! @LeventK just triggered some feedback I thought I should share, hoping it helps make this platform the best no-code solution - period.