Video Files on Appsheet - Upload file from App then view on App (No third party services)

[tsuji_koichi]

To film video natively on the app and save the video files to the cloud storage straight-away is one of the awaited features to have.

Saving video and audio file such as MP4, MP3 can be done by simply set up the data field type to “File” Then we have link to the those files with hyperlink but not able to view on the appsheet app.

This is super easy tricks.

Apart from file type data field, add virtual column with show type.

Set category to “Video”

And put the simple expression of text([Video File]), which will automatically create the public URL to access to the saved file and can be consumed in Show type column.

App seting is that s all.

By doing so, we dont need to host the video/audio files in Youtube or other place, and als we don t need to employ any other third party service. Just done by simple column set ups.

@Kirk_Masden

[tsuji_koichi]

At this moment, file picker on I phone not allowing to select MP4 files. I have asked support appsheet to investigate.

[Kirk_Masden]

Thanks for this tip. I need to look into it!

[Kirk_Masden]

I just tried it for an mp3. It works quite well. There are a couple of problems, though:

1. On my iPhone, the app goes to a black screen to play the video but on my Android phone it plays within the app.
2. On the Android phone, it would be nice if there could just be a bar for the audio – the space required for a video is not necessary.

Still, this is a very helpful tip for me. I hope the AppSheet platform will provide more support for playing mp3s inside of apps in the future. We need to have the same user experience in both Android and iOS.

By the way, it would also be nice to be able to play mp3s in the background . . . without a progress bar.

[tsuji_koichi]

Thanks Kirk. Yes, I agree. Mp3 player bar indicator height is too high.

I hope someone in Appsheet dev team review those post and post some feedback.

[Fabian (Fabian Weller wAPPlabor)]

Thank you @tsuji_koichi this is again a very clever workaround. Happy to have you here in the community

[Danny_Reyes]

Thanks very much @tsuji_koichi
We could share short video toturials with our apps users.

[tsuji_koichi]

Thank you for sharing your experience.
Good to hear my tips and tricks may help your life even a bit.

[Dario]

I also want to thank you for this tip, its a good feature. Additionally, what I have found is the following,

1. When you play a video or music file when using appsheet on mobile, the file will stop playing when you navigate to a different view, but if its on a tablet or PC (with tablet mode / externally opened) the media will keep on playing. This is the same whether the video is played from your cloud storage folder or an Embed from Youtube. The only workaround for this on mobile is to open the file and then click the back button on your mobile.

2. Even though the mutimedia player on appsheet has controls for looping, afaik there is no way to tell the audio / video file to loop, or to auto play. It would be nice if this was possible for files that we ourselves have stored on the cloud (and not dependent on Youtube changing how they handle auto play / embed codes etc). Maybe this feature is there and I just havent read about it yet?

[tsuji_koichi]

@Dario

Even though the mutimedia player on appsheet has controls for looping, afaik there is no way to tell the audio / video file to loop, or to auto play. It would be nice if this was possible for files that we ourselves have stored on the cloud (and not dependent on Youtube changing how they handle auto play / embed codes etc). Maybe this feature is there and I just havent read about it yet?

I believe you need to post a feature request to get that function.

[Arthur_Rallu (Arthur Rallu [AppSheet])]

Hi, some of you might be interested in helping us test a new related feature.
See Wanted: Testers for Video Capture on Android devices.

[Harry_Holmes]

Great tip works brilliant on desktop. Did you get anywhere with finding out why MP4s can’t be uploaded on iOS app