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=YXBwTmFtZT1QQlBkYjIwMjEtMTQzMTQ2JnRhYmxlTmFtZT11bml2ZXJzYWxfZGF0YSZmaWxlTmFtZT11bml2ZXJzYWxfZGF0YV9GaWxlc18lMkYyMzFjM2ZjYS51cGxvYWRfZXN0aW1hdGUuMTk0MjEwLnBkZiZhcHBWZXJzaW9uPTEuMDAxNzk3JnNpZ25hdHVyZT1lNDVhMWQwNjI4ZThjN2I3OGM0YjY0YzE0Nzg3NzliNDI1OWM1YjJmNDQyOGU3YTA0MDU1YzY4ZjdjNmViOWQ3ZTM3OTc4Y2NhN2E1OGY2ODNjZmZjYzAyMTEzNjBlMDI=

I have tried TEXT([col]) but it still doesn’t work

How are you doing this?

What did this output?

the same
https://www.appsheet.com/get/?i=YXBwTmFtZT1QQlBkYjIwMjEtMTQzMTQ2JnRhYmxlTmFtZT11bml2ZXJzYWxfZGF0YSZmaWxlTmFtZT11bml2ZXJzYWxfZGF0YV9GaWxlc18lMkYyMzFjM2ZjYS51cGxvYWRfZXN0aW1hdGUuMTk0MjEwLnBkZiZhcHBWZXJzaW9uPTEuMDAxNzk3JnNpZ25hdHVyZT1lNDVhMWQwNjI4ZThjN2I3OGM0YjY0YzE0Nzg3NzliNDI1OWM1YjJmNDQyOGU3YTA0MDU1YzY4ZjdjNmViOWQ3ZTM3OTc4Y2NhN2E1OGY2ODNjZmZjYzAyMTEzNjBlMDI=

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=YXBwTmFtZT1QQlBkYjIwMjEtMTQzMTQ2JnRhYmxlTmFtZT11bml2ZXJzYWxfZGF0YSZmaWxlTmFtZT11bml2ZXJzYWxfZGF0YV9GaWxlc18lMkYyMzFjM2ZjYS51cGxvYWRfZXN0aW1hdGUuMTk0MjEwLnBkZiZhcHBWZXJzaW9uPTEuMDAxODAyJnNpZ25hdHVyZT00NmZkZDI5Njc0NmQ1NjRlZTgyM2Y5ZjMwMzQxZWFmZmRhMWJiYTMyMTdiMTMwYjVjY2NjNzUzM2QyMGM1ZWZmNjBiNzExOTgyMDBmZWU0ZjdiMGJiNDA3MWY0NTg3ZTg=

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.

1 Like