Announcement

Collapse
No announcement yet.

how to generate an url *link to a specific record.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to generate an url *link to a specific record.

    Hi there,

    for customers (not users, they don't have any login) i want to send a link trough mail so that the can alter a record in a form and save the result.

    I already understand how to mail a customer i'm not sure how to generate an url link to a specific record.

    The situation is as follows

    A user (logged in) makes a record in the record is also the email for the costumer.
    next i wan't to mail that costumer so that he receives a link to the record in the database. the costumer is not a user and has therefor no login credentials.

    The question is how to build a url link to a record so i can give that link in an email?

    any suggestions?

  • #2
    Hi rotrax,

    let's say:
    your project uses the domain named mydomain.com
    and you have a table with records having a field id
    and you want the customer to edit the record with the id=3

    Generate a new form with NO security and name it customer_edit for example
    go to Form settings > SQL > Where clause
    and add there: id = [id_in_url]

    temp.png


    Generate the form ...

    Then your url would be:
    When calling the url, the form will show the record with id=3 and let the customer edit the record.

    Hope this helps.
    Gunter Eibl
    email@GunterEibl.de

    asdw.de - Scriptcase & Open Source projects (German/English)
    scriptcase.coach - professional coaching for Scriptcase users (German)
    GunterEibl.de - About me (German)

    Comment


    • #3
      He GunterEibl,

      I will try and let you know. thanks for the response!
      Last edited by rotrax; 10-13-2018, 07:28 PM.

      Comment


      • #4
        He GunterEibl,

        Wel that did work quite well. thanks! for a little security i would like to pas multiple vars through the url. only question... how do you do that with php?

        i have this in my php script

        "https://www.keuzedelen.com/brixx/ond...tek?bpv_id_in_url={bpv_id}&st_id={st_id}";

        but after the & the url in the mail stops (works still though) been seen as url. i tried

        "https://www.keuzedelen.com/brixx/ond...tek?bpv_id_in_url={bpv_id} . & . st_id={st_id}";

        also not working

        any suggestion

        Comment

        Working...
        X