Hello,
I have an AppSheet application (planning and management application) with the following data tables ( Google Sheet spreadsheets)
- I have a Product Master table- this data table is read only. And the google sheet which this table references uses a QUERY function to compile the data. ( At the moment, there are couple of different sources from where I have to get this data based on certain conditions which is why I am using QUERY function. )
- I also have a mapping- which machine needs to produce what product in how much quantity. For this, I am using a table view. Here, there is an action- which opens up a form to the “Plans” ( see below ) table with some auto-filled values. For that I am using the LINKTOFORM function. This works without problems.
- Then there is the Plans table. Here I am storing the production plans for each day. This table has several slices based on the dates- the one that is causing the problem has the filter condition: [date] > today() - 7. This table has a product ID column which is an enum with base type ref to the Product Master table. Based on the Product ID, there are app formulae that I am using- such Product Description, which again comes from the Product Master.
I have the following issue with the Plans quick edit feature:
At times, in the quick edit, if I want to change the Product ID, I don’t see the Product ID that I want to enter in the dropdown. But this product ID is present in the Product Master. Please find attached the screenshots of this issue.
What might be causing this issue? What is the solution to this problem?
This is in the Quick Edit feature.
But the same Product ID can be found in the Product Master table. See below.
The the Product ID available in the dropdown when editing through a standard form, rather than the quick edit method?
Thank you for the response!
I am not aware of such issue in a standard form, as whenever the user opens the form the product ID is auto filled by the action LINKTOFORM. This works well. But I am not aware whether the same issue happens in a blank standard form.
I would first open the standard form directly in the editor and see if you have the same issue. If it doesn’t then the issue might be with the quick edit feature.
However, I am guessing this might be due to your use of the QUERY in your spreadsheet. Since a QUERY is not static data, it might be causing these intermittent issues.
Okay thank you so much! I will try opening the standard form and checking the issue.
I see. But the issue that I have posted, I’m sure that that product ID (B001) was always there in the output of the QUERY function. I’ll post my QUERY function here:
=UNIQUE({QUERY(IMPORTRANGE(some range, some range), “SELECT Col1 WHERE Col1 IS NOT NULL”); QUERY(‘Sheet1’!A3:A, “SELECT A WHERE A IS NOT NULL”); QUERY(‘Sheet2’!A2:A, “SELECT A WHERE A IS NOT NULL”); QUERY(IMPORTRANGE(some other range, some other range), “SELECT Col1”) })
B001 is part of the first QUERY function, so it is always selected.
Kindly suggest what I need to try.
Thanks a lot for the help!
I am not sure how the quick edit function works, so someone can chime in if they know. It might not have anything to do with the use of QUERY, just my first hunch.
To test, you can just quickly change the QUERY data to static data by copy and paste, and then see if you still have the issue. Then you can always just put your QUERY back afterwards if it is not the problem.
If static data doesn’t seem to solve the issue, I would put in a ticket with the help desk since it means there is probably an issue with the quick edit feature
I checked the issue in the standard form. I was able to add the same Product ID in a standard form but not in the Quick Edit. Please find attached the images.
The following is a standard form.
The following is from quick edit.
Okay. How do I put a ticket with the help desk to raise this issue?
Thanks a lot!
You can submit a ticket at https://support.google.com/appsheet/gethelp?hl=en
However, I am still curious about your images above. In the standard form, the only option from the drop down is the same id (C152) that was already in the field.
It would be nice to see an example where the standard form had different options and then what that looks like in the quick edit. Perhaps in the quick edit mode it will only show options that are different from the already select option.
Again, just guessing here.
Thank you so much for your help @lynchk21 . I raised a ticket and the issue is solved now, hopefully.
To just clarify your point: the issue was the same even with different options. So instead of C152, if I had typed only C1, there would come multiple options but none was C152 ( even when the already selected option was different. )
Thanks again for helping!
Awesome - I appreciate your response and I am happy to learn some things along with you. I hope it gets resolved by the support team!
