This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I want to store exactly the same data as the QR code contains. But when
I add an entry through scanning the QR code, blank spaces will be all
deleted when it is stored to the Google Sheets. Before saving the entry
the data will be like this. [)> 06 P...
Problem: The format Rule is not working. Situation: The other table’s
format rule is working. Comment: I looked up many articles in the
community, but I could not find any solution. Please, tell me what is
wrong with this. Thank you.
Problem: There are only two (or few) entries in a primary view after the
new entry creation. (Originally, I have hundreds of entries.) Situation:
This issue started today. The other apps have the same problems. I
created a new app but the issue happe...
Error & Warning : “Unable to find values for validation in ‘Sheet_Name’”
(WARNING EMPTY ENUM) Purpose: To find the column that is missing the
associated data validation list. Problem: The Error & Warning does not
tell me which column is missing the d...
Hi, are there any other options to filter out blanks without using a
slice? I can’t figure out where to put ISBLANK() expression. Thank you
in advance.
Steve! Thank you so much. It worked! I set a new column with this
MID([QR Code],LEN([QR Code])-9,9) as “Initial Value” and set this column
as “Key”. Then the App started to detect duplicates. Since the “Fake
Space Problem” is not solved, I had to twe...
Steve: My guess is that the apparent spaces in the scanned data aren’t
actually spaces, but instead some other character that display as spaces
that are removed as invalid when saved or used elsewhere. I doubt
there’s anything you can do to fix this ...
Thank you, Steve. Let me answer your question one by one. Where does it
appear this way? It happens when I scan a QR-code in Form-View. Copy and
paste from where to where? I copied from the input area of the Form-View
and pasted it to Google Drive’s ...