Exporting data to Excel

This is an example of a "Proposal", and in it, there is the "Radio" column with two stations, but I want to extract their data (which are in the main table) into ExcelThis is an example of a "Proposal", and in it, there is the "Radio" column with two stations, but I want to extract their data (which are in the main table) into Excel

 

I'm developing an application with two tables:

1. The main one is called 'Radios', containing basic information of various radio stations.

2. The second table is called 'Proposals', where there is a column titled 'Issuers'. This column is of type enumlist and references the main table, 'Radios'.

How can I create an action that generates an Excel spreadsheet containing information about each radio station selected in a given proposal?

Solved Solved
0 4 280
1 ACCEPTED SOLUTION

If you trigger the Bot from the Proposal record, you can write the formula in the Excel template something like <<START:SELECT(Radios[KeyColumn],IN([RadioStation],[_THISROW].[Radios]))>>

If you want to trigger the Bot from the Proposal record, you could add an additional DateTime column to your table and then action button would write new timestamp with the expression NOW().

View solution in original post

4 REPLIES 4

If you trigger the Bot from the Proposal record, you can write the formula in the Excel template something like <<START:SELECT(Radios[KeyColumn],IN([RadioStation],[_THISROW].[Radios]))>>

If you want to trigger the Bot from the Proposal record, you could add an additional DateTime column to your table and then action button would write new timestamp with the expression NOW().

The final version for my case looked like this example: <<START: SELECT(Rรกdios[Row ID], IN([Row ID], SPLIT([_THISROW].[Emissoras], " , ")))>><<[Row ID]>><<END>>

Thanks!! 

 

You're welcome!

Top Labels in this Space