Transfering file data between 2 sheets

I am trying to transfer file data between two sheets, but I just need that TEXT from the file column. When it transfers instead of just transfering the text

universal_data_Files_/231c3fca.upload_estimate.194210.pdf

it transfers thisโ€ฆ

https://www.appsheet.com/get/?i=YXBwTmFtZT1QQlBkYjIwMjEtMTQzMTQ2JnRhYmxlTmFtZT11bml2ZXJzYWxfZGF0YSZm...

0 10 210
10 REPLIES 10

I have tried TEXT([col]) but it still doesnโ€™t work

How are you doing this?

What did this output?

but when I look at the column in the original sheet it appears like this.

universal_data_Files_/231c3fca.upload_estimate.194210.pdf

I am doing this through the action Data: add a new row to another table using values from this row

Seems to work for me.

unfortunetly its not working for me. I am trying to go from a mysql database to a google sheet. Not sure if that matters

Againโ€ฆ

i have two tables of data. one in a mysql database and the other is a google sheet. I set up an action to add a new row to another table using values from this row. One of those values is a file. I wish to transfer the text from the file column of the mysql database to the google sheet. I thought it would be simple, but every way I try to just transfer the text it spits out this on the google sheetโ€ฆ

https://www.appsheet.com/get/?i=YXBwTmFtZT1QQlBkYjIwMjEtMTQzMTQ2JnRhYmxlTmFtZT11bml2ZXJzYWxfZGF0YSZm...

Does it output the same when you test the expression from the expression assistant?

What is the column type of the destination column in Google Sheets? If it is an Image column, maybe try it as a Text column.

it works when I make a VC with the text, then transfer the VC to the spreadsheet.

Top Labels in this Space