Skip to main content Besuchen Sie uns auf der TDX in San Francisco oder bei Salesforce+ vom 5. bis 6. März, um die Entwicklerkonferenz für die Ära der AI-Agenten zu erleben. Jetzt registrieren.

#Quip14 diskutieren mit

I am creating a calculator where I want to take the calculated values from two cells and divide them. E.g., cell A2 and A3 are both cells with basic formulas referencing another cell. I need to divide the two values in these cells. When I use the Divide formula, a value of zero is returned. Does quip have a limitation with using a formula referencing a cell with a formula that references another cell?

@* Quip * 

1 Antwort
0/9000
1 Antwort
0/9000
Lucy C fragte in * Quip *

I recently updated my device to iOS18 and since then, my iOS Quip app has stopped showing the editing toolbar that normally appears above the keyboard.

Is this a known regression? How could I report this to the developers? As you might imagine, the app is not very functional when I cannot access necessary utilities like indenting, H1/H2, @ mentions, etc.

 

Details:

- Quip app version: iOS v8.65.0, fully updated

- Device: iPhone 12 Pro

- Device operating system: iOS 18.2, fully updated

Customer impact:

When editing a document in the app, I am missing the toolbar that lets me control important formatting options such as: indent, set style (e.g. H1 or H2 headings), @ mention, etc.

Repo steps:

1. Create a quip document

2. Navigate to that document in Quip's iOS app (I don't have another iPhone so cannot isolate if the device and/or OS is unique to the problem)

3. Tap to place cursor anywhere

4. Keyboard opens to begin typing 

Expected: a menu formerly appeared above native keyboard, showing options to indent, change heading type, etc (see screenshot)

Actual: the menu is missing above the keyboard (see screenshot)

5. Dismiss keyboard and repeat steps 2-4 if it does not reproduce initially. The issue reproduces in both landscape & portrait mode.

Note: I have observed the menu appears exactly once (the very first time the keyboard opens), but then goes missing/absent for all subsequent editing, until the app is force quit again.

4 Antworten
  1. 30. Jan., 18:27

    Hello @Lucy C. Salesforce Support created a new known issue for this. Here is the link if you want to report it as affecting you. 

0/9000
Ryan Lam fragte in * Quip *

Just got logged out of Quip. Previously was using Authy for 2 factor authentication and somehow the Authy profile for Quip got deleted. Trying to log into Quip requires authentication code which I cannot get because it was deleted from Authy. No way to get a new Quip QR code to setup 2 factor authentication as new.

#Quip

2 Antworten
  1. 29. Jan., 13:37

    what if I do not know who is the admin, as this is a global partner site...any idea how to find it? thank you

0/9000

Hi all, 

 

Is there a way to prevent the Daily Digest emails from being sent out to users? I know users can turn the notification off in Quip it's self but is there a way to turn it off for all users in an org? 

 

Thanks in advance

1 Antwort
0/9000

Hi, 

 

I am looking to report on Account plans (Quip documents linked to Accounts) where i would like to report on the below 

a) Quip document creation date 

b) Quip document created by 

c) Number of Quip documents attached to an Account 

 

I had a look at the Quip engagement metric guide

https://help.salesforce.com/s/articleView?id=xcloud.quip_template_metrics.htm&type=5

however it provides metrics on Quip document usage and not the above. Can someone advise if this is possible? 

 

Thanks 

Abu

1 Antwort
  1. 24. Jan., 07:06

    Hi @Abubakar Badgail

    Hope you are doing well, 

     

    Currently, Salesforce does not provide direct reporting for Quip documents linked to Accounts with the specific details you are asking for (creation date, created by, and number of Quip documents attached to an Account). The Quip engagement metrics focus on usage data, not the details of document associations. 

     

    To achieve this:

     

    1. Custom Solution: You could create a custom object or fields on the Account object to track Quip document details manually or via automation (e.g., using Apex or Flow).
    2. API Integration: Use Quip's API to fetch the required data (e.g., creation date, creator, and count) and store it in Salesforce for reporting.
    3. Third-Party Tools: Explore third-party tools or integrations that might bridge this gap.

     

    Without customization or integration, native reporting on this specific data isn't possible. 

     

    I hope you find this answer helpful. 

     

    Regards  

    Sunny Patwa

0/9000

Hi,

 

I'm looking for support for one of Salesforce Labs API named "Salesforce Tasks Quip Live App". It allows Salesforce tasks to be modified in Quip. However, we noticed that clicking any modifiable date fields will show blank elements until you decide to reload the frame. Anyone familiar with this issue or encountering the same issue?

Salesforce Labs - Salesforce Tasks Quip Live App - Issue modifying date fields in QuipQuip_Task_Date_error_img2.png

Best regards,

John Michael Modina

 

#Quip

 

@* Quip *

1 Antwort
0/9000

I'm using the python automation to integrate an external data source (survey results) into quip.   I'm able to call the api and add rows, get the table-id, etc.  but I'm unable to add a spreadsheet column programatically.   I'd like to add a new column with a survey question as the heading if the survey question does not exist in the table yet.

 

I've tried AFTER_SECTION after the last heading id, but get an error.  I've also tried to update the entire document with REPLACE_SECTION and the table id,  but get an error to the effect of "body too large".   

 

Here is my latest try:

document = quip.get_thread(quip_spreadsheet_id)soup = BeautifulSoup(document['html'], 'html.parser')table = soup.find('table')if table is None:    print("No table found")    return# Find all heading rowsrows = table.find_all('tr')if not rows:    print("No rows found in the table")    return# Get the first rowfirst_row = rows[0]# Find all cells in the first row (headings)cells = first_row.find_all(['th', 'td'])if not cells:    print("No cells found in the first row")    return# header rows are now in cellsheaders = []headerIds = []for i, cell in enumerate(cells):    if i == 0: continue    content = cell.get_text(strip=True)    headers.append(content)    headerIds.append(cell.get('id'))last_id = headerIds[-1]header = "newHeader"print(f'adding header: {header}')response = quip.edit_document(    thread_id=quip_spreadsheet_id,    format="markdown",    content=header,    section_id=last_id,    operation=quip.AFTER_SECTION)print(response)

 

Is there some incantation of /edit-document that can be used to add a spreadsheet column? 

 

#Quip

 

@* Quip *

2 Antworten
  1. 30. Dez. 2024, 16:20

    Thanks @Ashwini Garwandha

     

    I've seen many of the documents above and have been able to use the API,  just not to add a column.  That particular API command appears to be missing or is not obvious to me in the above docs. 

     

    I am able to make minor edits to the documents via the automation API.  I've been able to get authentication and basic usage patterns working, such as changing cell values.      I have not been able to add a column.  If I try to upload the entire spreadsheet via replace,  it is too large for the API and I get an error.   

     

      I know that it is possible to just add a column, because the web interface can do it. The web interface however does not use the automation API that is publicly documented (as far as I can see).  It appears to use a google protocol buffers based protocol via HTTP POST.   I have not gone through the effort to try to RE that protocol, and even if I do,  there is a very good possibility that the automation API won't handle it. 

     

    AI's such as out internal AI, AgentForce and  others are not able to provide a working answer.  

     

    Do you have any simple formulaic example of an invocation that will add a column with a name "NewColumn"?   This would be very helpful. 

0/9000

I want to find the row number of the last instance of data in a quip spreadsheet.   I've tried various incantations, none appear to work as intended.    I've tried various suggestions that appear to work in other spreadsheet programs. but not in quip. 

 

I want to do something like: 

 

= MAX( // find the largest row number in the returned array

MAP( 'Table'!D:D, // apply the search function to each item in the target column

LAMBDA( x, // construct a function of x to return a row number if predicate matches

IF(

REGEXMATCH("^\s*" & B2 & "(@|\s)*", // match a user id from current table

ROW(x), // if it matches, return the row number

0 // if it does not match, return 0

)

)

)

)

but unfortunately LAMBDA and MAP do not appear to exist.   Any suggestions would be helpful

 

@* Quip *

 

#Quip

3 Antworten
  1. 30. Dez. 2024, 15:50

    Thank you @Ashwini Garwandha for your answer.  However this was the first thing that I tried and also a common answer from Agentforce, Our internal company AI and the external AI that I tried.  I was not able to get any incantation to work. 

     

    I tried various incantations of FILTER and ROW.   ROW does not appear to have a variant that will operate on an array. 

     

    ROW('SheetName'!D:D) 

    does not produce an array.  it produces a single cell with value "1"

     

    =ARRAYFORMULA(ROW('SheetName'!D:D)) 

    also does not work, with the same results. 

     

    If I create a temporary row in the source document I am able to get it to work, but this is rather ugly and requires extra input for the maintainers.  In this case,  Column I contains the Row Count and column D contains the enumerations and B2 contains the target. This works,  but is ugly:

     

    =MAX(FILTER('SheetName'!I:I,'SheetName'!D:D = B2))

     

    Replacing the explicit row count in the document with the ROW function did not work,  I'm assuming due to the behavior mentioned above. 

    =MAX(FILTER(ROW('SheetName'!D:D),'SheetName'!D:D = B2))

    If quip was modified such that items that expect a scalar apply that function to each item of an array,  (as most other spreadsheets seem to do) then it would work.   However, I bet that would break some corner cases in currently working spreadsheets.  Instead,  if the team chose to implement the MAP/LAMBDA solution then this entire class of issues would have a workaround. 

     

    I'm just looking for a solution to this particular problem at the moment though,  not trying to solve the world :) 

0/9000

Hi all, I have a question we are new to Quip and setting up a template in Quip. I'm running into an issue where I can't get the report to filter properly down to the right account when I am on a salesforce record. It pulls in all the accounts. I can not find anything and its driving me crazy. Thanks!

2 Antworten
  1. 26. Nov. 2024, 17:08

    Hi @Kacy Hangca, set the report you wan to use up with a filter on Account ID where Account ID is blank so you can then use a dynamic filter in the quip template to pull in the record ID from the ID your Quip doc is linked to. 

     

    On the quip template set the report filter to be dynamic and in the Field Name box use the mail merge syntax to populate it with the Record ID. When the quip doc is created from the Quip template it'll then pull in the record ID to the filter. 

     

    I hope I've explained that in a way that makes sense! I've attached images of the filter from my template report and how I have the dynamic filter setup on the report in the Quip Template if it helps. I have this on a child object that hangs off the account so I'm using a lookup field on that object to get to the Account ID I need.

0/9000