I get the following error while trying to build a โGet Newest Change Log Valuesโ process that calls a process โGet Newest Change Log idโ and then tries to return the values from the newest change log by using the id it got from the called process:
Column id in expression โ[Newest Change Log].[id].[Action]โ does not contain a reference.
โGet Newest Change Log Valuesโ Process
โGet Newest Change Log idโ Process
id expression: MAXROW(โChange Logโ, โDateTimeโ)
Hi Liam,
When โidโ is returned, it is being returned as a text type, so you could not really do chaining dereferencing.
you can probably trying using the Select() expression.
For example,
Select(Change Log[action], [log id] = [Newest Change Log].[id])
thanks!
Ideally, it would retain the original column type. The behavior you describe is not intuitive and adds complexity and confusion. Nothing else in AppSheet behaves that way.
Could the โReturn Valuesโ be adjusted so the user selects what type is to be returned? Just like in setting up a table column?
Or could it auto-assign based on the returned value?
@Steve Agreed, thanks Steve!
Thanks both @Steve and @trawinseeds for your suggestions!
We will look into this feature request to support use case like yours.
Iโm curious what use case you were trying to support with the current approach.
This is one of the perfect confusion with us.
When it comes to โProcess inputโ, are you really sure that we are able to pass the โlist of IDsโ to it?
On the other post, I have been repeatedly pointing out that the one step with โcall another proces with initial process inputโ is actually doing the same as task (action) would do, i.e. STEP can manipulate the column value which is completely new with Automation. Yes, action can change the value of the target columns and field, but now we are able to do the same stuffs with process input, which is giving me (at least) confusion, until I get to know and understand what it is.
The nostargic action to change the value using value in column in this fields can be done by process input nowadays.
Alright, backing to the subject, we are really able to pass the list of ids for recors to the process input???
Hi,
sorry for the confusion โ no we cannot pass a โlist of IDsโ to a processโs input (which means we donโt support running the same process on a batch of inputs yet, but we are planning to add this with something like a ForEach step).
What I meant above is
Thanks!
So on this sample case, just wrap by any() should work then.
Any(Select(Change Log[action], [log id] = [Newest Change Log].[id]))
I adjusted the โNew Change Logโ step process โGet Newest Change Log idโ return value to โLog idโ and used your suggested expression
Any(Select(Change Log[action], [log id] = [Newest Change Log].[id]))
In the โReturn Valuesโ step within the โGet Newest Change Log Valuesโ and it reports the following error:
Output โActionโ is invalid: Unable to find column โLog idโ, did you mean โidโ?
Hi Liam,
Would you mind emailing support@appsheet.com with details of your app and allow access to your apps โ go to https://www.appsheet.com/account/account#_tab_acctConfig and check the option that enables support access.
We would like to understand the use case better and investigate.
Thanks!
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |