Re: Table access filters

Gunasuriya_Ravi · 07-09-2020 04:14 AM

I am having a table A,i am having a column status,

I need to access the table in readonly mode ,when the status is approved

else it should be in add,update,delete

can anyone suggest the expression

Pratyay_Rakshit

If you are thinking of tweaking the Are Updates Allowed? property in the table, it applies to a whole table rather than the row itself.

You can set an 'Editable if column constraint for a vital column that you don’t want to get changed after the Column Approved? is set to yes.

Or you can go to the ‘Edit’ action for the table and define an availability condition that depends on the Aproved? column

LeventK

@Gunasuriya_Ravi
A table is completely either a read-only or not, you cannot adjust that property as per row level. You can type a simple expression in the system Edit action, so that if a particular row’s [Status] column value is some value (i.e. approved), than the row becomes ineditable.

NOT([Status] = "Approved")

Gunasuriya_Ravi

Its working,I am having another doubt ,i need to show the records from today() date from 30 days before approved records in one view

i need a specific detail view for the row link when i add a new record through the workflow email

can you suggest any expressions

LeventK

Sorry, but I haven’t understood your problem. Can you elaborate?

Gunasuriya_Ravi

Question 1
I need to show the approved records in one view which is approved 30 days before from today’s date ,suggest any expression to filter
Question 2
I am having a workflow when the record is added ,through email mode
In the email i have attached the template
I need to sent the new added row through the template , which deep link i need to use

LeventK

[Approval Date Column] + 30 >= TODAY()

LINKTOROW([KeyColumn], "YourDetailViewNameHere")

Gunasuriya_Ravi

i am actually using a docs has email template ,how should i need to define has clickable link in that template docs

when i click the click here ,i need to go the added row detail page

LeventK

@Gunasuriya_Ravi
You can use <<_ROW_WEB_LINK>> template variable

Gunasuriya_Ravi

<<_ROW_WEB_LINK>> : Hyperlink that refers to the added or updated record in your app. For example, you can include this URL in a workflow email to allow the email recipient to easily open the added or updated record, displayed as ‘Click Here’ hyperlinked.

This can be used in a Body Template and an Attachment Templates. It cannot be used in the Body property

i am using this ,but its showing random detail view ,i need to define a specific detail view ,

Is this possible?

LeventK

I have given you every reference to accomplish what you are asking. Please refer to those documentations, make your hands dirty, try a couple of expressions referenced and you can ask back if you can’t.

Gunasuriya_Ravi

i am using row web link ,its working but i cant define a static detail view .for the workflow,its taking a default detail view