BOT AUTOMATION CREATE URL

[Nadhirah]

Hi, I have an error when trying to create a url link using actions and automation in appsheet. I am not sure why this happened since before this it works fine. I did not change anything for the bot either. Below is the bot I created and the actions.

 

Example of the code used to create the URL:

Concatenate("https://www.appsheet.com/template/gettablefileurl?",
"appname=",encodeurl("appname"),
"&tableName=",encodeurl("table name"),
"&filename=",encodeurl([column name])
)

Error I find when clicking the generated link: 

Invalid parameters to request table file URL.

Any ideas where the error or problem I did?

(Edit: Btw, I already disabled below buttons)

[Nadhirah]

Hi, Can anyone help me regarding this matter? I can just make this bot again but I would like to know the issue why it is not working. 

[Nadhirah]

I tried making a completely new bot but it is not working. Can anyone help?

 @AleksiAlkio @TeeSee1  Sorry I tag you like this but do you have any ideas why it is not working?

[イルカのえっちゃん]

I would like to know the same thing.
I have tried many times before to set up the exact same settings as in this post, but I have not been able to try to get it to work.

[Nadhirah]

I tried investigating by testing the bot but it returns error like that when the column is not even empty. I am so clueless as to what is going wrong here. It works fine until I tried to change ownership however I already added the source to the app and also make a new bot. 

I also noticed that link created have unfinished link. For example: 
https://www.appsheet.com/template/gettablefileurl?appname=JKRRH4G9-66200218&tableName=Work%20Order&f...

help :')

[Nadhirah]

@Suvrutt_Gurjar 

Help :')

[jballester]

Hola!!

Test automatically and dynamically.

CONCATENATE(' https://www.appsheet.com/template/gettablefileurl?appName= ', ENCODEURL(CONTEXT(AppName)), '&tableName=', ENCODEURL(CONTEXT(Table)), '&fileName=', ENCODEURL( [ IMAGEN]) )

Ref.Tips & Tricks

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Quick-Tips-Easy-Expression-to-construct-URL-to-r...

[Nadhirah]

Concatenate("https://www.appsheet.com/template/gettablefileurl?",
"appname=",encodeurl("appname"),
"&tableName=",encodeurl("Tablename"),
"&filename=",encodeurl([Image])
)

This is the code I used. It works in making the link however somehow it could not get the filename. 

[Suvrutt_Gurjar]

Hi @Nadhirah ,

It sounds that you are trying to set the URL in a URL type column of an image column in the same record.  You are trying to set this URL probably as an event action on form save.

If so, my testing showed that I am able to create such an URL using the same expression you used.

The right hand side in the image below shows the URL created.

The URL in the app opens the image as shown below

The expression in the action is as follows:

[Nadhirah]

Hi @Suvrutt_Gurjar , Thanks for responding. I can generate a url however the filename is not written there. I am not sure why appsheet cannot get to the filename. As you can see on my earlier post. There are links being generated but when it reach the filename it is unable to. Is there any solution for this? This happened after I changed ownership. Will that affect anything?

[イルカのえっちゃん]

I have been struggling with the same problem for a long time, and I think I finally found the cause.
I am Japanese and usually use Japanese for table names.
I just tried the same thing with the table name in English.
Then the image is displayed.

[Nadhirah]

Mine is english too T^T. This happened right after I transferred the ownership. I think that might be the issue --> The directory but I need the solution.  Thank though

[Nadhirah · Accepted solution]

I found already what the issue is ... wasted my time for a mere require button for the tempoh masa response that were shown on the error when I tested the bot. I should've look into that first ").  Sometimes I feel like a fool hahahah. Thank you guys for responding @Suvrutt_Gurjar @イルカのえっちゃん @jballester . I appreciate it.