Forum Discussion

preetiverma's avatar
preetiverma
Qrew Member
5 years ago

copy the data from one field to another using click on button on same record it

Hi ,

how can i  copy the data from one field to another field in same record it in one table.

like when user click on button on email it will add the  current user name in to field on same record it.
i tried with the below code but it is not working.

URLRoot() & "db/" & Dbid() &"?a=API_EditRecord&rid="& URLEncode ([Record ID#])& "&_fid_10= & URLEncode([Loggin User])" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()&"?a=td")

fid_10 where i need to copy the value of current user which saved in loggin User.

Thanks

------------------------------
preeti verma
------------------------------
APIs and custom code
Buttons

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    Can you tell us what is not working?  Is it a syntax error?  if so what is the error? If nota syntax, what is not working?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    Qrew Captain
    5 years ago
    Hi Preeti,

    You should enclose your [Login User] field with the ToText() function and there is also a quotation missing after the 10= (it's erroneously after the User reference). You may also need to verify that the app does not require app tokens (or add the token to your formula).

    URLRoot() & "db/" & Dbid() &
"?a=API_EditRecord" &
"&rid=" & URLEncode([Record ID#]) &
"&_fid_10=" & URLEncode(ToText([Loggin User])) &
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td")ā€‹


    I have not 'debugged' the rest of your code, but these omissions stood out to me as the likely issues provided all else is correct.


    Let me know if this helps šŸ˜ŠšŸ‘

    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------