HOW TO INTEGRATE ZOHO SHEET WHIT ZOHO SHEETS FOR A UPDATE EXITING RECORD IN ZOHO CREATOR FORM
I HAVE ONE FROM IN ZOHO CREATOR AND SOME DATE IN THIS FROM BUT NOW I WON'T UPDATE THE EXITING DATA WHIT ZOHO SHEET IT IS POSSIBLE OR NOT IF IT IS POSSIBLE TO UPDATE HOW?Add custom day and date to Date Field
Hi Everyone, I have case like this. If Day in Date Field A > 8 in current month, Date in Field B should be 23/Date A + 1/Year (dd/MM/yyyy) And if Day in Date Field A <= 8, Date in Field B should be 23/Date A/Year (dd/MM/yyyy) Example: The created date is 09/05/2019 so end date will be 23/06/2019 The created date is 07/05/2019 so end date will be 23/05/2019 Sorry about my description. I cann't find function to add custom date like this to end date.Restricting Fields in Bulk Edit
I have carefully hidden some fields in my Form as I do not want them to be available for editing. However, it seems that enable bulk edit allows any field to be edited. Is there any way to stop this? Thanks, Julian"Work offline" in Zoho Creator ?
Is there any way to work offline in Creator? I have some forms that I fill out... take notes in... at a location that does not have internet. It would be great if I could do that there, and then come back to the office and have all that data upload to Creator's database. Thanks for any input. TomMigrating info from Form A to Form B
Hi guys, I have a question regarding migrating information from a form to another form. I have same fields on both forms, and here is my code when customers fill out the form A, and I migrate them to form B. insert into User_Sign_up_Form [ Added_User=zoho.loginuser Yellow_Fever=input.Yellow_Fever ] But somehow when I update the report for my form B, It created a new customer in the list as shown below. I am supposed to update the second row. I appreciate any help! - SallyHow to add a flow created in Zoho flow into Zoho creator app?
Total newbie, so apologize for being lost. I have a contacts app in creator, and set up the Zoho Creator Gmail flow for when a new record is added. I tested by adding the new record, and my email is sent to me. However, there's no indication in Creator, that there's a flow working with my app. It only shows flows I created inside the App under the workflow tab. Should I be able to see Zoho Flows from here?Date filter: this week
Hello, If we use a calendar report we can configure what the first day of the week shall be. I can not find this feature any other reports (pivot chart, pivot table, list report etc). The default setting is Sunday. In my country the first day of a week is Monday. So I always have to use user filter in reports if I want to have "this week data" from Monday to Sunday. Anyone can help if the feature still exists somewhere and I miss something, or any tip how to hack it? Kind regards GeorgeCombining 3 reports into 1 with all information
Hi, I am working for a NGO and we have 3 different sign-up forms for activities. Is there a way that we can combine all 3 forms and sort the information according to the volunteers' name? For example, volunteers provide their basic info in Form A, activities they want to join in Form B, and availability in Form C. How can I combine all of these into a single report? Thanks. - SallyUsing Formula Field with a Lookup Field
Hi all! I have a form with a "Job ID field", a "Client" field and a "Job Title" field. The "Client" field is a Lookup field that pulls from a client database form. I made a new formula field to merge all of the information in an easy to read format for other forms. The expression is this: Job_ID + " - " + Client + " - " + Job_Title But what I get is: Job ID - XXXXXXXXXXXXXXXXXXX - Title Instead of the Client field from the client database form I get the 19 digit ID of that entry instead. Is thereI am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address
I am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address - including using "zoho.loginuserid" both with and without the quotation marks. The user does not receive the email, I am sending out several different emails from the same field - is there a limit to the number of emails one can send from a single Form Action? Inside this Form Action I have another email that I send to myself and I do getUploading photos as fields in a Zoho Creator Template
I have an application where one of the fields is designed to store the photo of a user. I used the image category field and the system seems to accept it when I load from a JPEG on my PC - it identifies the jpeg and assigns a number on the screen. However, when I look in the Report, the JPEG is not there. When I edit the record and I add the same JPEG in edit mode, it does accept the JPEG and the the JPEG does appear when I view the edited record in the Report view. Attached is a screen capture ofFilter lookup to select only most recent
Hello, I have a lookup field where I want to select ONLY the most recent record that fits certain criteria. For example, if a customer renews their service plan, I may have two records that filter to [Customer_Name == input.Customer_Name && Transaction == "Purchase Service Plan"] and I'd like to select the one with the most recent Date. Is there a way to do this? Thanks, ElizabethPopluate a drop-down list with data from another database
Popluate a drop-down list with data pulled from a database that is maintained by another form....Does anyone know how to do this?Separate content from a String
Hi All, I have a form with a rich text field and a single record. The field contains email content My second form sends a notification using the fields value as the body of the email, on success. The problem I have is separating deluge (such as + input.anyfield +) from the HTML / content. My code so far: EC = email_form[ID == 45644000002346541]; req = EC.email_content.toString(); sendmail [ from :"zoho@zoho.com" to :"chris@zoho.com" subject :"subject for this email" message :req ] is it possibleMore than one attachments in Send Email task
Is it possible to attach more than one file(PDF- Record Summary) in the Send Email task inside Zoho Creator?There MUST be a way to update records in bulk. But how?
I have created a database with thousands of records. Occasionally, I need to add another field, after which I need to populate those fields for each of the records. I do NOT want to go through each record one by one to update it. The information I need is in a spreadsheet, which can be converted to CSV or TXT file with no problem. The information is numerical, therefore the bulk update option does not work, as that allows you to update records only with the same value. Most databases allow youRemoving Export Options without Embedding
Seems to me we should be able to customize a standard list's export options. Maybe there is something undocumented to add to the report definition? Cheers, John WhitneyIP Address of internal LAN subnet
I have a published form that I would like to restrict to a certain subnet in our organization's lan. Windows ipconfig gives me the internal ipaddress, but the system field zoho.ipaddress gives me the external public ipaddress. is there any way I can get the internal address on our internal network?Delete Records using Multiple Conditions
Hello, I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created. Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.Pivot Chart / Subforms
Hello, I am not able to use subforms in pivot chart so i think subforms and pivot chart relation is not supported. Are there any future updates on this topic?Send an Email
I want send an email data to my department which is approved in last month.Financial Year
Hello, How do i setup financial year in Zoho Creator.Help counting and calculating date differences in arrayed data
I have no experience scripting for arrays, indexed lists, etc. and need help to deluge-script the following business need: I have an event_form, with a date_field, employee_field and time_field. For any given date, the number of records logged by a employee varies from one date to another. I also have a summary_form, with a date_field, employee_field, recordcount_field, and hours_field. The script should accomplish something like this, diagramed in plain English: For each date_field value and eachWhy does this formula not work?
I have a simple formula that is triggering as true, even when it is not. if(Due_Date != null && Status!="Repeat") { input.Status = "In Progress"; } In that formula (my interpretation), if the date is not blank and the status is not Repeat, then change status to In Progress. However, it is still firing when the status is Repeat and changing the status to In Progress. I think it has something to do with the date field. Really not sure why it isn't working at expected Any help? Thanks MichaelCounter from 2 dates
Hi I am trying to create a formula where it gives me a number by subtracting difference from 2 dates Completion_Counter (result to go here) Reported_Date - Date_of_Completion = Completion_Counter Is this possible so for example if report by date is 20/11/2019 and Date of Completion is 21/11/2019 the result on Completion Counter will be 1 Thank you for helpRecord Summary Template - can we use deluge script?
Hi, I have created a Record Summary Template using the template builder. While showing a record I would like to show other record from different table which do not have any link to the current record/table. I tried to look for a way to insert deluge script but could not find a way to do it (no script builder button or template definition section). Is there anyway to use deluge script in Record Summary Template? Thank you, PambudiWhat is Bidirectional Lookup? Why we use? and how to use?
can anyone explain me what is Bidirectional Lookup? Why we should use? and how to use? Thanks in advanceHow to parse Json in Zoho Creator
I have a huge json which i get from crm sales order . I have to parse that json and upload that record into zoho reports. Is there any way in creator to parse json. { "response": { "result": { "SalesOrders": { "row": [ { "no": "1", "FL": [ { "content": "15 Taco Bar - Fabio 5/12", "val": "Subject" }, { "content": "Emily Fabio", "val": "Contact Name" }, { "content": "Confirmed for Delivery", "val": "Status" }, { "content": "Chaska Private Parties", "val": "Account Name" } ] } ] } }, "uri": "/crm/private/json/SalesOrders/getRecords"configure list report
Hi, I need a list report where I have aggregated values. For example I can see the ordered qty of a product per rows, and I can get the total when I edit the report. I want to see the total only, and would like to hide the rows, the total comes from. Can it be solved? Thank you Georgehow to copy data from one field to another ?
With my data base at Zoho, how is it possible to copy data from one field into another ? Thank youAuto populate a feild from another form
as aboveUpdate date calculation when viewing report
So I am using the Zoho.currentdate to calculate the days a "listing" has been live. Here is the Deluge Script: input.Days_on_market = ((zoho.currentdate - input.Date_listed)) / (1000 * 60 * 60 * 24); It does not seem to be updating when you pull up a record in view. Is there a way to do that? The other option is to schedule it to update every record on a schedule, but that seems overly taxing and not the right way to do it. Suggestions? ColinHow to Copy field dat from one form field into another
as abouveFormulas in Zoho Creater
Hello Everyone I'm new to Creator, and I'm trying to teach myself Creator, but I'm having trouble. I'm trying to create a formulator inside Creator that will subtract to dates. I tried using standard Excel logic, but it doesn't work. Is there a "cheat sheet" that one can use to assist. I have tried using the tutorials on the web (Youtube) , but the interface they use is outdated and looks completely different from the one I'm seeingAuto Populate, Pre fill, Auto Fill
I have one form that collects customer information and part information. What would be the best way to pre fill / auto populate the customer information from the current users previous entries? Ideally the customer name field would auto fill (or a drop down) when typing then populate address, city, state, and zip. Any ideas?Enabling invoice payment in Zoho Creator
Hi, I am trying to execute the following: Generate invoice > add payment button to the invoice with a Forte payment Gateway (already configured) > email invoice to a customer > customer pays directly through the invoice. I know how to create the invoice and populate the customer information. Im having difficulty integrating the payment function into the invoice so that it can be sent as an email. A tutorial or series of steps on how to do this would be fine. Thank youHow do I fetch data from two forms into a third form?
I'm new to creator and am setting up forms for a seed bank. I have three forms:Collection, Storage, and Withdraws. On the Withdraws form I want to fetch data from both Collection and Storage forms based on the user input in a lookupfield with unique values (this field is on all three forms). I set up the Storage form to fetch specific fields from the Collection form, and thought I could just daisy chain and fetch all the necessary fields for the Withdraws form from the Storage form, but it doesn'tzohocreator.exe
Need Help with zoho migration through console mode Add Or Update zohocreator.exe <filepath> <username> <password> -e <appname> -au <formname> <fieldname> <columnname> Eg : zohocreator.exe c:\myfolder\ordermanagement.csv john mypassword -e order-management -au order_form Items Products I have created the following .bat zohocreator.exe G:\Filing Cabinet\_PAYROLL\time card import files\JobNumber_auto.csv username password -e Time Card -au Jobs Job_Number Job_Number No records are added or updated whenAlternative to Migration Tool
Does the community know of any alternatives to the Migration Tool, especially for updating existing records? We have for three days not been able to use the tool due to an unspecified error. So far Zoho Support have not been able to identify the error. I am also thinking, that MacOS users do not have the option to use the Migration Tool either, so maybe there is an alternative method available?Conditional Formatting for a custom Record Summary
I have created a custom record summary for a report. I want the conditional formatting from the report to work on the record summary as well. I know it is possible because it works on the default template. Can anyone help me to get it working for my custom record summary. Thank you very much in advance :)Next Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from aroundUsers Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" correspondingFile download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certainEnabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Top Contributors
Karunakaran G
【CSL】三井 翔
ishwariya.gurunathan
Valeria
pandapotan.s