Hello dear, I have a problem (Error 1109 url not valid). Who can?
Hello Arshak
It's very likely that the URL is invalid. If you direct your built URL to a label, you should be able to spot the error.
the info I sent buys, registers at this address What does Invalid address mean? Would you please tell me more details?
Show the full content of your first line in the join:
It simply means the address is wrong in some way and thus is rejected. Out of the many characters the address has, it wouldn't be a surprise to find a typographical error in there, which is why I suggested you need to look at the entire concatenated (joined) string (text). If you can't spot the error, post it here for us to try. Tim is a Google Docs expert.
Next time you post an image of your blocks, do this:
Right-mouse in the Blocks work area and select "Download Blocks as image"
https://docs.google.com/forms/d/13vZ7WN33bpJB8y25FvGxrGdOvD3Bud3h3tbXZ9Pn4qc/formResponse
Base URL to form looks OK. Opens up the form here. Can you open the form in your browser (incognito/private window, or not signed in to Google account) ?
You did have this working in your other topic, so what has changed since then?:
( I notice you do not appear to be using the replacement blocks to fix your decimals....although that wasn't causing a problem with the URL)
when exactly do you get that error message?
use Do it to debug your blocks, see also tip 4 here https://puravidaapps.com/learn.php
and post the result here... also make sure, all textboxes do have a valid input
see also Live Development, Testing, and Debugging Tools
Taifun
Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.
Hello dear friends. I will not be able to solve this issue anyway. Who will help me how to solve this problem?
It could be that the form/sheet has become corrupted (I have seen this before)
Try setting up a new form/sheet to test.
Alternatively, if your users will only enter data using the app (and not the form) consider a google apps script web app to submit your data.
ok friend thank you for what you said I will try to write about the result
I never trust a text block whose contents end in '...' .
I duplicate the text block, and split each clone at a reasonable location into front and back then use a text JOIN of the two parts. Each part that still is too long needs to be split again, until I can read every text block to the end.