Re: transfer action issues

msahines

hello all, i have a bot that is designed to transfer data from one sheet (form sheet) to a different sheet all together (main sheet). the form sheet gets its data from a form i fill out with 14 entries. i have a google apps script that is made to run when the form is submitted and it adds an http link into a 15th entry on the form sheet (the only entry on the form sheet that is not received from the form itself)... all of this is working fine, giving all the data and adding the individual http link to each row of the form sheet.

now for the bot, i have it set to wait for 5 minutes (minimum wait time) when it sees the name field not blank. after the 5 minutes it is set to take the row's 15 inputs and transfer the rows data to the corresponding fields in the main sheet. now it does transfer the information as expected for the 14 entries that came from the form itself but when it transfers the 15th entry (the http link) it adds all the http links in the 15th column that came before the current row and then the current row's link. (ie: transfered data for the first row's transfer: "http a"... second row's transfer: "http a, http b"... third rows transfer: "http a, http b, http c"... etc)

how can i get it to transfer just one http link from the current row's column 15 instead of appending?

Suvrutt_Gurjar

If you could share how you are transferring the data ( meaning by using an add action or using Json add ) and exact expression you are using for that 15th column, the community could suggest better and more definitive approach or a solution.

msahines

appsheet action that takes data from the form sheet(right) to the main sheet(left)

above is the action in appsheet (made as a bot but added this action) that is transferring the data that is in the table from the right (which all are listed correctly) to the data fields of the main table in a different sheet. i'm not really using expressions as the intention was to grab each cell info as it's listed and putting it in the other table's fields. every other field transfers the info correctly without any issues, it's just the last column which comes into the initial table as a url link. it doesn't appear to be a cell format issue as the actual link isn't modified. if i clear the initial table so there is no data, the transfer works perfectly. the next entry that goes in the second row of the initial table is listed correctly on that table. upon the transfer the appsheet action does transfer the new url into the other table but it puts the first row's url in, followed by a "," then puts in the new url for the second line.

i'm trying to describe the best i can, i can attach more screenshots if i know which ones will help further understand. but the above step is where the issue is coming from so if there is an expression i can add with the "form link b" to grab the last entry into the 15th column of the current row or even better the last filled cell of the specific row that the rest of the data is coming from, that is what i need help with.

Suvrutt_Gurjar

@msahines wrote:

(ie: transfered data for the first row's transfer: "http a"... second row's transfer: "http a, http b"... third rows transfer: "http a, http b, http c"... etc)

Thank you for the additional details. However unfortunately the details do not help in coming up with any suggestion. From the first post of yours that is highlighted above, it sounds that some kind of aggregating or list functionality is taking place while adding that 15th column.

You may want to share the type of column of the column [form link b] and its settings , if that is the column that is getting aggregated in the target table.

msahines

it likely is. here's the code in a virtual field added to the table. the virtual field was necessary as the bot action to transfer data was only usable by bringing the form into google appsheet. i brought in the sheet and table that holds all the responses from the form but for whatever reason appsheet is not allowing me to use that table. in the table is where the url link is put into the 15th column. so i put in the following code into that virtual column to reflect the data in the table that holds the url link:

judging by your response it seems this is what is making it happen, i just am unsure of what to put into the app formula as the virtual column needs something.

i have tried adding a field in the form itself to kick out a form link column in the form data itself so i didn't need to add the virtual column and adding a reference from that to the url field in the sheet column but nothing transferred (or maybe i used the wrong expressions)

Suvrutt_Gurjar

@msahines wrote:

for whatever reason appsheet is not allowing me to use that table.

It is not clear why Appsheet isnot allowing that table to be added unless it is not in the format expected by Appsheet.

It is definitely due to the column expression that the liist is generated.

scott192

In your screenshot here, you have told Appsheet to put the contents of a whole table into a single field 'Form Responses 5[form link]'. You should instead use something like [_THISROW].[form link] instead to get a single value.

msahines

thank you guys. that definitely was the cause, i happened to find another way to get it working properly through the table instead of the form and now i don't have to deal with that field. appreciate both of your times!