About jairod

jairod · 09-13-2022

I am running an automation bot with a json webhook task to the appsheet api with a <>{"codigo":"[_THISROW-1].[SKU]","productID":"<<[ID]>>","nombre":"<<[nombre]>>","material":"<<[material]>>","cantidad":"<<[cantidad]>>","udm":"<<[udm]>>"},<>]} I´m usi...

jairod · 08-27-2022

I have a table "woocommerce products" with a ref row relationship to a slice "product variations 2"When choosing (clicking) on an item from the related list (related product variations 2) the detail view opened is from a non-filtered row.The "product...

jairod · 08-16-2022

I have a child table with DateTime stamp like the following:It gets updated by a webhook everytime there is an update.I´d like to show a list of the most recent child records which are not repeated at the parent view.Any help will be greatly apprecia...

jairod · 08-16-2022

An automation bot where the first step is to check with an ISNOTBLANK condition started throwing an "Index was outside the bounds of the array" error message today. Up till 3pm the automation bot had been working properly for several weeks.Is this a ...

jairod · 06-05-2022

I have a parent and a child table, I need to add data to the child table with a 'Data: add a new row to an other table using values from this row' action which passes along the parent table ID value plus I need to be able to choose via dropdown ref o...

jairod · 09-13-2022

I´m copying the child records with an "execute sequence of actions" action which first asks for an input (the ID which will be used as the new parent) writes it to the parent table to the "NextParent" column, then sets a "trigger" value which fires t...

jairod · 08-28-2022

The odd thing is that I checked the DateTime as well as the variation id columns to make a concatenated key which was unique due to the DateTime, however this is where I was getting the wrong result at the detail view.

jairod · 08-28-2022

I added a unique id column to the "product variations" table and it solved the problem!

jairod · 08-23-2022

I checked my formulas and was missing theSUBSTITUTE(Before concatenate.I fixed that and it works.

jairod · 08-22-2022

I was able to list the most recent items by using the following formula in a filter:DateTimeColumn] = MAX( SELECT( YourTableName[DateTimeColumn], [_THISROW-1].[pseudo_id]=[pseudo_id] ) )However the concatenate formula in the virtual column of the so...

My Stats

jairod's Bio

Badges jairod Earned

Recent Activity

appsheet webhook not writing parent data inside <<start expression

Item in Related list from slice opens not filtered detailed view

Most recent unique child records list.

Index was outside the bounds of the array

Action: copy data to child table with dropdown menu

Re: appsheet webhook not writing parent data inside <<start expression

Re: Item in Related list from slice opens not filtered detailed view

Re: Item in Related list from slice opens not filtered detailed view

Re: Most recent unique child records list.

Re: Most recent unique child records list.