Hi,
Is there a way to use the individual field values of multiple connected records as input for a pipe ? I need both values separate for an individual pipe request.
Say I have 2 connected records and each records contains a date e.g 1/1/1999 and 1/1/2001. Is there a way I can use these dates both in a single api request ? When I use the connected records function, I can only use total count of records value or sum of field values as input. This doesn’t work since it’s a date.
The option could be use different data tables for each records ( e.g table 1 date 1 and table 2 date 2) and connect them both to another table. But that’s not good for UX, since I cannot have 1 table containing the records, but instead have 2 tables on the page.
Anyone have a suggestion?