Delete a space

Hi, when I select something from a fusion table (for example SELECT ROWID FROM (tableid) WHERE Description = 'apple'), it comes out like this: 'rowid 2001'.

That is completely fine, but when I replace all text (segment = rowid ), it does not compute. NOTHING at all gets replaced, but if I remove the space at the end of the segment (segment = rowid), it works but leaves me with a space at the beginning of the rowid. In most cases this would be okay, but if you are updating or deleting a row, it won't accept the space at the beginning. Please help me!

--

 it comes out like this: 'rowid 2001'.

the result actually looks like this

rowid

2001

which means, there is an invisible new line character \n after the rowid

therefore convert the result into a list using the split block, just split at \n (new line)

the 2nd item of the list is the rowid you are looking for, in the example 2001

-- 

Thank you so much!

The only problem is that the profile page won't update (My app has a profile page and the user should be able to edit their profile. It works, but when the user finishes editing their profile, the profile page opens and it SHOULD be updated but it is not...).

Is there any way to 'refresh' the profile page?

-- 

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

-- 

Sorry for the confusion... 

Here is a picture of some of the code in the 'edit profile' screen.

As you can see, when 'save' is clicked, the changes are made to the fusion table and then the app opens another screen - the profile page which is meant to be updated with all the new information.

At the moment, this is not happening and the profile page has the same information as before. I know that the fusion table has been updated successfully, but I cannot get the profile page to show the updated information unless I go to a different screen and then come back.

So my question is: is there any way to automatically refresh the profile page?

-- 

you have to pass the changes to the other screen

How to pass values from one screen to another screen by Scott

alternatively: why opening another screen? why not using the same screen and vertical screen arrangements to simulate different screens? just set the arrangement to visible = false/true as needed

--