Search box is not putting Searched Data into Google Sheet

Hi, based on previous projects, I have tried to create a screen which would search across 3 columns in my Google Sheet for any textstring entered into the App’s Search Box (see below)

I have concatenated columns " MANUFACTURER ", "MODEL " & " CODE " into column " SEARCH1 "

I have done this so when a textstring is entered into the App’s Search box by the user, the textstring is also be consequentially entered into the GSheet cell ( MANUCONTENT!H3). But this is not happening. (Image below)

I cannot see anything wrong in my blocks ( below) but I know I have missed something.

Below is what is supposed to happen…!

Then the textstring should appear in the GSheet…

…which will then filter and return the GSheet values from MANUCONTENT!A3:H to the DVL (Aircraft_ICAO_DVL).

I have also previously tried using a List Viewer but the DVL, for me, feels to be the right solution for my requirements.

Could someone kindly glance over my problem as I am now suffering with “Block Blindness”.

The project is on my " AircICAOCodeSreen "

Here is the link to my project:

https://x.thunkable.com/copy/c3beaf478c7d8f0b7d03b0a89ebe9bf4

Best regards,

Andos.

1 Like

I have an old project doing a similar that I just tried it and it worked fine.

https://x.thunkable.com/projectPage/629382f4ba6f1b0012cf088d

It works with this Google sheet

Hi @muneer, that fixed that problem See blocks…!

GSheet Entry

However, I have now discovered that the DVL results are not showing on the App Screen. :pensive:

My DVL on Design page is set to “visible” (below) and my visibilty in my blocks appear to be ok.

My blocks

All my bindings are correct

…but my App screen is still blank

What am I not seeing?

Best regards,

Andos.

1 Like

You need to check if your DVL is actually bound to the correct Data Source connection.

There are things that you need to consider there.

  • If you have disconnected your Google sheet and reconnect it again then you need to reselect the data source in the DVL and rebind all columns.
  • If you make a copy of your project and then used a share link to get a copy of the project then all Data Sources will change to local and you have to reconnect again.
  • If you change in the custom layout design of the DVL then you need to reconnect again.

Hi @muneer, I have disconnected and then reconnected the DVL bindings after re-“syncing” the Source Data. But it still didn’t work so I replaced the variable blocks: text input blocks; and then the DVL blocks and then I finally started seeing the DVL on the App Screen. But, now the app is not returning the filtered data from the GSheet to the App Screen it is just returning the unfiltered data instead. However, the data in the GSheet is filtered. See below:

Opening Screen

But no data was present on the GSheet.

I quickly realised that after re-binding the GSheet I hadn’t changed the Source Data to MANUCONTENT.

Once that was rectified, I found the Search box in the App was no longer writing to the GSheet.

I then proceeded to recreate all of my blocks and now I am back where I started but now even more confused than before!

Why would this happen if I started again with all new blocks and Source refresh and using the rectified/ amended blocks?

This is the current state of my " AircICAOCodeScreen setup below. Can you see anything wrong with it?

Current opening Screen

Again not writing Search textstring to GSheet cell "H3"

My current blocks

Also, shouldn’t the " When the ICAOAircraftText_Input changes block be used?

This project is very important to my App as it is for providing Reference Data.

Best regards,

Andos.

1 Like

It will be very difficult to troubleshoot the project without access to it and its Google sheet.

I understand that you already provided a link. But this copy is now old and does not reflect the latest changes. Again, the copy of the project alone does not do a lot as your issue is testing it with the GSheet.

As a side note:
I can see that you are setting a variable to 1 and then use this variable to manipulate something with the DVL. This would not work.

1 Like

Thanks @muneer, what should I replace the variable with?

Here is the link to my GSheet: I am working from the MANUCONTENT tab.

Here is the latest link to my project:

https://x.thunkable.com/copy/8dac58dd4e1e74c563eec5efd7e01e14

Best regards,

Andos.

1 Like

Hi @muneer, I haven’t yet had a response from you to my last reply. However, I had finally got my " Aircraft ICAO Code Screen to write to the MANUCONTENT!H3 cell (in my “Search1” column) this morning. But when I came back to this project this evening there had been a bug in Thunkable which prevented me from further testing my success with the Search issue I had been having. So foolishly, I started to tinker about in my “AircICAOCodeScreen” because as this was the last thing I had altered in my project, I thought it was related. As a result, I have made a mess of everything.

I used your suggestion that you posted earlier in this thread: (Thunkable) to help resolve the “writing Text Input Searches to my GSheet” but it didn’t work until I used the blocks in the “when ICAOAircraftText_Input changes” block instead of the “When ManufICAOEntBtn1 click”. Now that part works flawlessly on the GSheet tab (MANUCONTENT).

Problem I now have should be simple (-even for me!). I just can’t get the results to display in the App. (below)

As soon as I start to enter a textstring into the Live Test text input box (ICAOAircraftText_Input1). (See below:)

The results are “instantly” shown as I type without the need to use the Enter button. :+1:

But now when I enter a textstring into the Search/ Text Input box on my mobile phone. The screen does not display any results at all but the data has been entered into the Text_Input box. See below:


"

Could you please look at my blocks below and tell me where I have gone wrong. Like I said earlier, this should be simple but I can’t figure it out.

Best regards,

Andos.

1 Like

I changed this
image

And removed this from the opens block.

image

It worked fine with me.

1 Like

Hi @muneer, I have tried your suggestion which works fine on Live Test but is still not showing on my mobile device. Any ideas?

Best regards,

Andos.