Validate file upload to create custom action

[Vexmo_Technologies]

Hi, Is possible to create a custom file picker for accepting custom extensions, in this specific case, I need to evaluate an .xlxs and convert data to JSON, for saving it on firestore collection.

Some advise?

[ThinhDinh]

So you need the ability to read an uploaded XLSX file and convert what you read to JSON?

[Vexmo_Technologies]

Yes, I try to get info from xlsx file and set as JSON. I think to find an answer. using the file upload button, but it allows to upload any file. First of all, I need to validate file type. I reach to get data as JSON using a lamda function, and implementing a call via webhook, but now I don’t know how to make for read the response data in glideapps from webhook

[ThinhDinh]

For validating a file type, I would use a custom form.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

When users upload a file, you can extract the file type from the URL of the file using JavaScript. Then you can validate using the result of the JavaScript column.

For the JSON part, I’m not sure what you mean. What exact columns/flows are you using to parse the info from the file? Can you provide some screenshots or a video?