Currently I am trying to build a form which some of its fields might get updated with values from cells of the sheet associated to the form. This should happen once user populates a field called ID.
1) I know that triggers can be used for such purposes, but I do not know if triggers can be bound to form fields on events such as "onEdit", or so. From this question what I understood is that a trigger in a sheet can open a form, but is there a way to have a communication the other way arround?
2) And furthermore, if the above question is feasible, then I would need a way to access given cells from the sheet. As a matter of fact, I would need to use functions like HLOOKUP for the column ID. And if found, then column A of that row should populate form field 1, and column B goes for field 2, e.g. From the Sheet point of view, no worries. But am I allowed to perform a HLOOKUP on the sheet, but executing that in the form?
3) Based on this other question I see that only way to prefill a field it is done by provinding field name and value through the form URL. So my question here would be if it is possible to have a trigger bound to a change event of ID field, that would force to execute an URL with the prefilled fields?
I checked all these servicies but none of them seem to provide cell values from a sheet.
Hope anyone can help me figuring this out. I know I have too many question here, but I rather wanted to have all of the in only one question.
Regards!!
Aucun commentaire:
Enregistrer un commentaire