Link to Google-information

[parksidecreator]

Hi there,

We are working on an app that shows stores information like social media, location and contact information. We are also presenting opening hours through the app - would it be possible to link these to the opening hours the specific store has on Google?

Thank you in advance,

Benjamin
Patkside.

[rafaelroseira]

@parksidecreator

urs the specific store has on Google?

Thank you in advance,

Benjamin
Patkside.

I am working on a similar External Collection Benjamin. I am almost there to make it work perfectly, but I am facing a small issue raised on this forum topic:

External Collection - Query Param provided later, but required during EC creation

Hello everyone. New Adalo user here… establishing my first External Collection. I was able to create and successfully test the External Collection, but one of the required parameters is an “input”. To create and test the EC, I used a dummy value (“test”), but I need this string to be provided later on, during the app use, using a Text Input field. When trying to crate the EC without this “input” attribute, the test shows error (which is expected, since the “input” is mandatory for my query). …

I am using Google Places API, which I believe will help on your task.
Take a look on this Google Places Documentation:

Cari Tempat  |  Places API  |  Google for Developers

This forum topic also helped me a lot:

Google Place Details as external collection

Referencing recommendations from Adalo staff on previous topics Google place api returns results incorrectly and Get Google Place Images via API, I have set about trying to add Google Places as an external collection. Structuring the request per Google’s documentation, I am able to get a response. Unfortunately, Adalo consistently returns “An error occurred when calling Get All” and that it “Could not find any results. Are you sure the Results Key is correct?” I’ve attached some screenshots. Co…

I hope I could help you.
Take care.
Rafael

[parksidecreator]

That you for your response Rafael.

What does it mean that you almost have it figured out? Does it work to link the stores opening hours to a text box in Adalo?

Kindly,
Benjamin

[parksidecreator]

@rafaelroseira

I am working on a similar External Collection Benjamin. I am almost there to make it work perfectly

This is by the way great news for me!
Excited to look at the articles you linked.

[rafaelroseira]

I say I am almost there because the External Collection can be created and tested, but with a dummy value for the parameter “input”, required in the Google Places API’s “Find Place”. But, when using the External Collection to go to Google Places and perform any query, the EC uses the dummy value provided during EC creation. Because of that, the real input provided in the screen I am creating is not used, since only one input is allowed.
If I can find a way to solve this issue, I will be able to use Find Place query to search for a place (based on a Text Field component value provided by the user) and then use Google Place API’s “Place Details” to request all the place’s details. In your case, this Place Details query can bring opening hours.
Take a look on the forum link I provided previously and you will get more details, including screenshot of what I mentioned here.

Take care.
Rafael

[rafaelroseira]

Just posted an update on my issue with a solution I found:

External Collection - Query Param provided later, but required during EC creation

Hello everyone. New Adalo user here… establishing my first External Collection. I was able to create and successfully test the External Collection, but one of the required parameters is an “input”. To create and test the EC, I used a dummy value (“test”), but I need this string to be provided later on, during the app use, using a Text Input field. When trying to crate the EC without this “input” attribute, the test shows error (which is expected, since the “input” is mandatory for my query). …