how to limit deleting item from repeating table - InfoPath Dev
in

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

how to limit deleting item from repeating table

Last post 09-21-2010 04:54 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-20-2010 12:42 AM

    • firouz
    • Top 200 Contributor
      Female
    • Joined on 02-24-2009
    • Iran
    • Posts 51

    how to limit deleting item from repeating table

    Hi

    I have a form that is work client based. I have repeating table in the form. users can select Item and click the " delete " button in the keyboard, So the content will remove. how can I limit the delete ? They should insert Item but not to have delete permission.

    Is there any solution?

  • 09-21-2010 04:54 PM In reply to

    Re: how to limit deleting item from repeating table

    Hi Firouz,

    If you want to prevent them from deleting data in items within a repeating table there are several techniques:

    1. Disable inserts and deletes the table
      TODO> doube click repeating table blue button in the designer and under default settings uncheck allow inserts and deletes
      • Pros: easy to do
      • Cons: heavy-handed
    2. Make fields read-only
      TODO> double click the cells in each column and check read-only on Display tab
      • Pros: easy to do
      • Cons: can't add data to cells, but rows can still be inserted or deleted
    3. Disable inserts and deletes using a condition
      TODO> double click the repeating table blue button in the designer and add a conditional formatting rule to disable insert/delete
      • Pros: easy to do, you can use the expression condition of "1=1" to make it always true
      • Cons: only good for read only items, but you can add a button to insert new items if you use qRules
    4. Make previously entered rows read-only
      TODO> add a conditional formatting rule that makes the value read-only based on some condition (for example, already entered data)
      • Pros: supports entering new data
      • Cons: last row is editable until new row is added, semi-complex xpath required to compare current index of row with count of table to allow entering new data, but easy

    Best of luck!

    Patrick Halstead
    InfoPath MVP
Page 1 of 1 (2 items)
Copyright © 2003-2012 Qdabra Software. All rights reserved.
View our Terms of Use.