You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm trying to be able to sort a formula column that can't be used for sorting.
I saw in a link that the next best thing is to use automation.
The idea is that when a new row is created, copy the value of the formula into a regular text column, and since the column is text, it can be used to sort.
The procedure described in the link is as follows.
start creating an automation with 'row create' type
query the newly created row to get it.
use the update row step to modify the desired column of the row (copy formula value to regular text column)
My question is, in #2 above,
How can I get the row that was just created, the row that corresponds to the condition that triggered the trigger?
When I look at the query rows part in budibase automation, it basically fetches all rows, but I think I need to set a filter condition here to get the rows I want, the ones I just created.
I've specified _id in the matching filter, the method is binding, and the content of the binding is {{ trigger.id }} for the content of the binding.
But when I look at the output, all rows are returned.
I would really appreciate if you could tell me how to get only the rows that were created in the above step.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I'm trying to be able to sort a formula column that can't be used for sorting.
I saw in a link that the next best thing is to use automation.
The idea is that when a new row is created, copy the value of the formula into a regular text column, and since the column is text, it can be used to sort.
The procedure described in the link is as follows.
My question is, in #2 above,
How can I get the row that was just created, the row that corresponds to the condition that triggered the trigger?
When I look at the query rows part in budibase automation, it basically fetches all rows, but I think I need to set a filter condition here to get the rows I want, the ones I just created.
I've specified _id in the matching filter, the method is binding, and the content of the binding is {{ trigger.id }} for the content of the binding.
But when I look at the output, all rows are returned.
I would really appreciate if you could tell me how to get only the rows that were created in the above step.
Beta Was this translation helpful? Give feedback.
All reactions