menu
Logo
  • Why azing?
  • Blog
  • Help
ENarrow_drop_down
  • DE
  • EN
Suche in Checklisten
search
azing Logo ENarrow_drop_down
  • DE
  • EN
  • Why azing?
  • Help
info-tjeps
drive_folder_upload
  • homeChecklist Templates
  • south

folder_sharedDNN tricks

  • homeChecklist Templates
  • south

folder_sharedDNN tricks

Folders and checklists

  • check_circlePersonalized data using ActionForm

Parts (0) expand_more

These are small document-parts which are used in other documents. They are not a starting point for any real activity. Because of this, they will be listed further down and the search will not list them unless requested. 

This recipe is to describe the steps to create a website page where a logged in user can submit data that will be displayed to him/her only. Typical scenario is a website where you can tell something about yourself. In scenario below we let the visitor store where he/she wnet on a last vacation.

  1. Create a table in the database, like MyInfo
  2. Set the schem at dbo
  3. Create a column Id
  4. Make Id a primary key
  5. Make Id not nullable
  6. Create a column MyInfoGUID
  7. Create a column UserId
  8. Create a column like 'LastHoliday' in MyInfo
  9. Switch to your DNN
  10. Add ActionForm
  11. Add a field LastHoliday 
  12. Add button
  13. Add action to button : data - run sql query
  14. SET LANGUAGE DUTCH
    INSERT INTO dbo._MyInfo (MyInfoGUID,UserId,LastHoliday)
    VALUES (newID(),@UserId,@LastHoliday)
  15. Add bind tokens
    MyInfoGUID -> [MyInfoGUID:Value]
    UserId -> [User:UserId]
    LastHoliday -> [LastHoliday]
  16. Save
  17.  In the section FormEvents, create an action onInit
  18. Data - Run SQL query
  19. SELECT TOP (1) 
    dbo.MyInfo.LastHoliday
    FROM dbo.MyInfo
    WHERE (dbo.MyInfo.UserID = @Loggeinuser)
    ORDER BY Id DESC
  20.  
    Add bind token to onInit action:
    Loggeninuser -> [User:UserID] 
  21. Add an extract column:
    LastHoliday -> LastHoliday
Logo
Legal | Content Copyright CC-BY 4.0
bug_reportReport Bug
  • info
  • Links
  • Permissions
code Share
code
URL copied to clipboard.
Embed Checklist close
Copy Copy
Content Copyright

CC-BY 4.0

Translations

None

info-tjeps

QR-Code
azing.org/info-tjeps9264
/r/ykMHmmQS
View & Use

Public (can be used by everybody)

Edit & Admin

Default (all members can edit)

This catalog has a simple permission model, where all members have the same permissions. For advanced permissions, upgrade to Enterprise.

Here you can see how this document is used and linked by other documents

Used in (0)

Others referencing this

Uses these (0)

Documents linked from this document

How it Behaves

How this document is categorized changes how it behaves.

This is a main document, it is listed normally and appears in search result.

Type

This is a Checklist. Lists are converted into checkboxes.

Get something to say?

Comment to start a discussion or make a note
send

please log on to chat

close

Durchsuche ganz Azing