Looking for help in finding out why my code is not behaving how I expect it on a kind of intermittent basis

Hi. I have this problem contained within another thread but I thought it would be less confusing to post a new thread to ask how to find out what is wrong with my blocks/code. I hope this is OK.

I have created a very simple app that is essentially a poll. It takes two random items (OptionA and OptionB) from an airtable source called “ThisOrThat”. The idea is when a user chooses an option by clicking the OptionA or OptionB button, it will show them how may people chose each option (as a percentage) based on previous choices made by other users.

The code uses another airtable source called “Combinations1” to find out if the specific OptionA vs OptionB combination has already come up. If the combination does not exist, it creates an entry in Combinations1 and adds 1 to the chosen option in the VotesForA or VotesForB field and then updates the percentages in the airtable as accordingly. The app labels should then display the text in the PercentA and Percent B fields.

If the combination of OptionA and OptionB does already exist, it is just supposed to update the VotesForA or VOtesForB field by adding 1 to the chosen option. Then again, the labels should update to show the percentages.

The issue is I am getting strange behaviours using the blocks I have created. It seems like things work sometimes but they do not other times and I can’t work out why. I will follow up this message with the blocks I am using and also a description of the behaviours I’m seeing.

As mentioned, here are the blocks I am using for the above:

Below is an account of the behaviours I’m seeing (apologies this is so long):

When screen 1 opens:

  • Everything looks OK
  • I get a random item for Option A and a random item for Option B appearing as text in the OptionA and OptionB buttons

When I click OptionA button:

  • The table in Combinations1 updates correctly - a record is created with the correct OptionA and Option B and 1 is added to the VotesForA field, and the PercentA and PercentB fields update
  • The labels do not update - the label text should be appearing now as the text in the PercentA (100) and PercentB (0) fields, but nothing is displayed

Click Option A again (same 2 options on screen as before)

  • The table updates correctly i.e. VotesForA updates to “2”
  • The labels update correctly too - LabelA text shows as 100 and LabelB text shows as 0

If I click Option A button again (still same 2 options as before)

  • Nothing happens - table record does not update

Click Option B (same 2 options as before still on screen)

  • Table updates correctly - 1 added to VotesForB, PercentA and PercentB fields also update
  • Label text does not change (it should change to the new PercentA and PercentB values)

If I click Option B again (same 2 options as before)

  • Nothings happens - table fields do not update

If I now click “Another”

  • Gets 2 new random items for Option A and Option B as it should, and shows these as the text in the OptionA and OptionB buttons
  • The label text stays on screen from the time before I pressed “Another”. I would want this to reset when “Another” is clicked

Click Option A button

  • Table updates correctly - two new items are added in a new row and the VotesForA field updates to “1”
  • The label texts disappear where I want them to now show the PercentA and PercentB values for the new row

Click Option B button (same 2 options)

  • Table updates correctly, so now shows VotesForA=1, VotesForB=1, PercentA=50, PercentB=50
  • Label texts also update correctly - shows LabelA text as 50 and LabelB text as 50

Click Option A again (same items)

  • Table updates OK - VotesForA=2, VotesForB=1, PercentA=67, PercentB=33
  • Labels on screen do not update though

Click “Another” and get 2 options that are already an existing combination in the Combinations1 source

Click Option A

  • Nothing happens - no records update

Click Option B

  • Table updates OK - correct existing records update

Try clicking Option A again

  • Creates a new entry in table with a different (incorrect) Option A but the correct Option B - it should not create a new record line at all as the combination already exists

Click Option B

  • Table updates correct Option B but wrong Option A existing combination

Click Option B again

  • Updates table with new record containing both wrong Option A and wrong Option B

If anyone can help in any way it would greatly appreciated. Thanks!

I don’t want to speak for others here but for me, this is way too much information to be able to help you in an efficient manner. It would take me a long time just to understand everything you’ve posted, much less figure out what might be wrong and then work on solutions.

If your project is this complex, you might consider either paying someone to help you as a consultant or contacting Thunkable Support (assuming you have at least a Pro plan).

Hi @tatiang . OK thank you, I appreciate the feedback. Apologies for the complexity. Would it be best if I remove the topic?

I just didn’t know if anyone would be able to quickly spot anything in the code that didn’t look right.

There’s no need to remove the topic! It’s never a bad thing to ask a complicated question. I just know that the time I would need to invest in something this long is only worth it if I’m getting paid… just being honest.

Someone else might have the time and interest. But if you don’t get any help here, consider simplifying things, if possible, to ask a single specific question.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.