• Vaibhab Shah
  • NEWBIE
  • 10 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 19
    Questions
  • 8
    Replies

Hi,

I need to find whether lastmodified is changed after certain time ie.10 am. How to achieve this in formula field?

Rgds,
Vai.
Can anyone help me with the below requirement?
I need to find whether lastmodified is changed after certain time ie.10 am. How to achieve this in formula field.

Rgds,
Vai.
Hi,

I have a scenario 
1.  On editing if the city is changed to Ahmedabad.
I have written the below formula, action is only getting fired on creation of a new record but when i am editing by changing the city to Ahmedabad it is not working.
2. While creating a record on Account, i need to check whether city and State both are not blank.

OR
(
AND
(ISNEW(),
NOT(ISBLANK([Account].City__c)),
NOT(ISBLANK([Account].State__c))
),
AND
(
ISCHANGED([Account].City__c),
IF(([Account].City__c) == 'Ahmedabad', true, false)
)
)


Can anyone help me on this?

Rgds,
Vai


 
Hi,

I have a scenario 
1. While creating a record on Account, i need to check whether city and State both are not blank.
2. On editing if the city is changed to Ahmedabad.
I have written the below formula, action is only getting fired on creation of a new record but when i am editing by changing the city to Ahmedabad it is not working.

OR
(
AND
(ISNEW(),
NOT(ISBLANK([Account].City__c)),
NOT(ISBLANK([Account].State__c))
),
AND
(
ISCHANGED([Account].City__c),
IF(([Account].City__c) == 'Ahmedabad', true, false)
)
)

Can anyone help me on this?

Rgds,
Vai


 
Hi,
I have created 2 process builders on the same object Opportunity say PB1 and PB2. PB2 is getting called from the PB1.

Configurations done on PB1 (Point 1 and Point 2)
1. In PB1 I have selected the ActionType as Processes and Selected PB2 in Processes. PFB the screenshot.
This image is not available because: You don’t have the privileges to see it, or it has been removed from the system


2. In Set Process Variables section I have set only one parameter that is SObject as mentioned in the screenshot below.
This image is not available because: You don’t have the privileges to see it, or it has been removed from the system

On clicking the value a new pop up came I have selected the first option that is
Select the Opportunity record that started this process

Facing problem in PB2(the called Process Builder)

1. Advanced Section is not appearing while setting up the criteria.
This image is not available because: You don’t have the privileges to see it, or it has been removed from the system2. 
Unable to schedule any action from PB2.

Question is whether any action can be scheduled in the sub process builder?


Rgds,
Vai
Hi,
I have created 2 process builders on the same object Opportunity say PB1 and PB2. PB2 is getting called from the PB1.

Configurations done on PB1 (Point 1 and Point 2)
1. In PB1 I have selected the ActionType as Processes and Selected PB2 in Processes. PFB the screenshot.
User-added image


2. In Set Process Variables section I have set only one parameter that is SObject as mentioned in the screenshot below.
User-added image

On clicking the value a new pop up came I have selected the first option that is
Select the Opportunity record that started this process

Facing problem in PB2(the called Process Builder)

1. Advanced Section is not appearing while setting up the criteria.
User-added image2. 
Unable to schedule any action from PB2.

Question is whether any action can be scheduled in the sub process builder?


Rgds,
Vai
Hi,

I have a custom object which has 2 fields:
1. Immediate Parent (Self Relationship)
2. Ancestor

Requirement given below with scenarios:
Created a record 1 --> here Immediate Parent and Ancestor is blank.
Record 2 --> Immediate Parent is record 1 and Ancestor is Record 1
Record 3 --> Immediate Parent is record 2 and Ancestor is Record 1
Record 4 --> Immediate Parent is record 3 and Ancestor is Record 1

There is one more record say Record 5 (Immediate Parent and Ancestor is blank).

Now I change the immediate parent of 2 to 5 so the outcome should come like:
Record 2 --> Immediate Parent is record 5 and Ancestor is Record 5
Record 3 --> Immediate Parent is record 2 and Ancestor is Record 5
Record 4 --> Immediate Parent is record 3 and Ancestor is Record 5

How to acheive this in trigger?

Thanks,
Vai
Hi, 

I have developed a lightning flow where I am able to colour the options (Yes in green and No in red). The same thing I am unable to do in mobile version.
How to achieve this when seeing from mobile.

Thnx,
Vai
Hi,

I have a requirement where I have to update one field of all the opportunities of one account record if any opportunity record is updated.
eg: On updating a custom field on Op1 record of Acc1 record, I will fetch all the opportunity records of Acc1 record and will update the custom field for the fetched opportunity records.

Thnx,
Vai
Hi,
I have used a lightning input text. I want to allow only alphabet and restrict numbers, special characters and space.

Thnx,
Vai
Hi,

I am having an apex controller with the following method whose return type is again a different class. Below is my code:

@AuraEnabled
public static AccountPagerWrapper getData (Decimal pageNumber ,Integer recordToDisply)
    {
        Integer pageSize = recordToDisply;
        Integer offset = ((Integer)pageNumber - 1) * pageSize;
        
        String queryCount = 'SELECT count() FROM Account';
        
        String finalQuery = 'dynamic query';
        List<Account> returnList = new List<Account>();
        returnList = database.query(finalQuery);       
        
        AccountPagerWrapper obj =  new AccountPagerWrapper();
        obj.pageSize = pageSize;
        obj.page = (Integer) pageNumber;
        
        obj.total =  database.countQuery(queryCount);  
        obj.accounts = returnList;
        return obj;
    }

public class AccountPagerWrapper {
    @AuraEnabled public Integer pageSize {get;set;}
    @AuraEnabled public Integer page {get;set;}
    @AuraEnabled public Integer total {get;set;}
    @AuraEnabled public List<Account> accounts {get;set;}
   }

Can anyone tell how to assign the dynamic query results in accounts property of the AccountPagerWrapper. Line is marked with bold.

I am simply assigning the dynamic query results in the property but it is throwing an error while binding it with the table.

Thnx,
Vai
Hi,

I am apex controller with the following method whose return type is again a different class. Below is my code:

@AuraEnabled
public static AccountPagerWrapper getData (Decimal pageNumber ,Integer recordToDisply)
    {
        Integer pageSize = recordToDisply;
        Integer offset = ((Integer)pageNumber - 1) * pageSize;
        
        String queryCount = 'SELECT count() FROM Account';
        
        String finalQuery = 'dynamic query';
        List<Account> returnList = new List<Account>();
        returnList = database.query(finalQuery);       
        
        AccountPagerWrapper obj =  new AccountPagerWrapper();
        obj.pageSize = pageSize;
        obj.page = (Integer) pageNumber;
        
        obj.total =  database.countQuery(queryCount);  
        obj.accounts = returnList;
        return obj;
    }

public class AccountPagerWrapper {
    @AuraEnabled public Integer pageSize {get;set;}
    @AuraEnabled public Integer page {get;set;}
    @AuraEnabled public Integer total {get;set;}
    @AuraEnabled public List<Account> accounts {get;set;}
   }

Can anyone tell how to assign the dynamic query results in accounts property of the AccountPagerWrapper. Line is marked with bold.

I am simply assigning the dynamic query results in the property but it is throwing an error while binding it with the table.
Hi,
I have a table to display more than 10 columns in lightning. How to make the div or table fixed with resizable columns.
I am using html table and looping using aura:iteration ( i don't want to use lightning: datatable as there are some issues with lightning datatable) as I want to query from salesforce object.

Thx!
Vai
Hi,
I was asked in an interview the below question:
There is a custom object X and there is an Account Object.
Account object and X object do not have any relationship.

Whenever I will create an account record, I need to populate a text field with a value of X object on acccount object. This needs to be acheived using configuration and no customization.
Hi,
Can anyone of you help me with the code for multiselect combobox? I don't want duallistbox, I want a combobox or picklist where user can select more than 1 value.

Thanks,
Vai
Hi, 
Can anyone let me know how to develop searchable dropdown in lightning? My requirement is to show multiple searchable dropdown in a div.

Thnx,
Vai
Hi, 
I have a list of list of map.
List<list<map<string,string>>> customer

How to the retrieve the values of the map in Apex?
Thanks in adv.

Rgds,
Vai
 
Hi,

I have used one lightning button at the end of the row which is getting distorted and not in shape with the other columns in a row.
Initially there will be any row in the table. only header with columns will be visible. On clicking the Add row, rows will be added.
I have attached the screenshot.

PFB my code:

<template>
    <lightning-card class="slds-card_boundary" icon-name="custom:custom13">
        <h1 slot="title">{title}</h1>
        <div class="slds-card__body slds-card__body_inner">
            <table class="slds-table slds-table_bordered slds-table_cell-buffer slds-m-bottom_large"> 
                <thead>
                    <tr class="slds-text-title_caps">
                        <template for:each={columns} for:item="column">
                            <th key={column.apiName}><div class="slds-truncate">{column.label}</div></th>
                        </template>
                    </tr>
                </thead>
                <tbody>
                    <template for:each={rows} for:item="row" for:index="index">
                        <tr class="inputRows" key={row.uuid}>
                            <template for:each={columns} for:item="column">
                                <td key={column.apiName}>
                                    <c-input-table-cell record={row} field={column.apiName}></c-input-table-cell>
                                </td>
                            </template>
                            <td>
                                <lightning-button value={index} variant="brand" label="Delete Row" onclick={removeRow}></lightning-button>
                            </td>
                        </tr>
                    </template>
                </tbody>
                <tfoot>
                    <tr>
                        <td><lightning-button variant="brand" label="Add Row" onclick={addRow}></lightning-button></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </lightning-card>
</template>


 
Hi,
I have a requirment where I have to develop a lightning web component UI to insert more than 1 record into Account object by clicking Add Row button and then inserting all the records by clicking Submit button. Can anyone help me on this? 
Hi,
I was asked in an interview the below question:
There is a custom object X and there is an Account Object.
Account object and X object do not have any relationship.

Whenever I will create an account record, I need to populate a text field with a value of X object on acccount object. This needs to be acheived using configuration and no customization.
Hi,
I have a table to display more than 10 columns in lightning. How to make the div or table fixed with resizable columns.
I am using html table and looping using aura:iteration ( i don't want to use lightning: datatable as there are some issues with lightning datatable) as I want to query from salesforce object.

Thx!
Vai
Hi, 
I have a list of list of map.
List<list<map<string,string>>> customer

How to the retrieve the values of the map in Apex?
Thanks in adv.

Rgds,
Vai
 
Hi,

I have used one lightning button at the end of the row which is getting distorted and not in shape with the other columns in a row.
Initially there will be any row in the table. only header with columns will be visible. On clicking the Add row, rows will be added.
I have attached the screenshot.

PFB my code:

<template>
    <lightning-card class="slds-card_boundary" icon-name="custom:custom13">
        <h1 slot="title">{title}</h1>
        <div class="slds-card__body slds-card__body_inner">
            <table class="slds-table slds-table_bordered slds-table_cell-buffer slds-m-bottom_large"> 
                <thead>
                    <tr class="slds-text-title_caps">
                        <template for:each={columns} for:item="column">
                            <th key={column.apiName}><div class="slds-truncate">{column.label}</div></th>
                        </template>
                    </tr>
                </thead>
                <tbody>
                    <template for:each={rows} for:item="row" for:index="index">
                        <tr class="inputRows" key={row.uuid}>
                            <template for:each={columns} for:item="column">
                                <td key={column.apiName}>
                                    <c-input-table-cell record={row} field={column.apiName}></c-input-table-cell>
                                </td>
                            </template>
                            <td>
                                <lightning-button value={index} variant="brand" label="Delete Row" onclick={removeRow}></lightning-button>
                            </td>
                        </tr>
                    </template>
                </tbody>
                <tfoot>
                    <tr>
                        <td><lightning-button variant="brand" label="Add Row" onclick={addRow}></lightning-button></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </lightning-card>
</template>


 
Hi,
I have a requirment where I have to develop a lightning web component UI to insert more than 1 record into Account object by clicking Add Row button and then inserting all the records by clicking Submit button. Can anyone help me on this?