Zoho Creator Update a Task in Zoho Projects (DELUGE) Error 6890
Hello, I'm trying to update a simple task on my Zoho Projects using Deluge on the app i've created on Zoho Creator. This app haves a worklow that runs on record update. This is my function on Zoho Creator Workflow: And this is the error i get everytime: I've tried to change the function, for exemple to only get the projects status or something else. Everytime i get this error. Thanks
Zoho Creator integration with Zoho Forms
Hi, I´m searching for a way to integrate the Zoho Forms with Zoho Creator databases. Is there a way to do that? So that instead of the creator forms I can use the Forms from Zoho Forms. Thanks!
Search Feature not working
Everything has been working fine with my Zoho Creator database, until, today, when the search feature brings up no records, when I know there are many. Every other aspect of the program is fine. Is there a system issue today with the system upgrade? Thank you.
フォーム/アンケートにデータベースを表示する
フォームやアンケートにデータベースの結果を反映させることはできるでしょうか。 ルックアップで選択肢にできるのは存じていますが、特定のデータベースの結果を表示させたいです。 例えば日付付きの売上のデータベースで、1月分の売上を表示する、のような形をイメージしています。 Kintonではフォームの特定の値を拾って、他データベースの結果情報を表示させることができたかと思いますが、zohoでお同じようにできるか教えていただけますと幸いです。 何卒よろしくお願いいたします。
render image on embedded form
I have a page I have created in Zoho Creator with HTML and deluge to walk through a form and display images. I then published the page and view it embedded in an IFrame on another site. Unfortunately the images don't render. Is there a way to publish the images so they render?
Count Function
Hello, There is form called Delivery Challan where there is a subform in which there are 2 lookup fields Design No. and Shade No. Now the problem i want to validate whether the particular design no or shade no exist in the stock or not and for that i believe count function is the only feasible option (if there is another do recommend). Now i have tried the code but it seems to doesnot work with subform i guess. Following is the code: if(Outward_Type == "Fabric") { for each rec_Fab in Fabric { Fab_Obj
Conditional Panels
Hello, My company needs a customer dashboard that shows the status of submitted documents. Is there a way to have a panel on a page show only when the document has been submitted? And we also need a way to show a certain icon when the document is submitted (like a check mark or an alert if the doc is expired)
Updating Records in a Form from Excel
Hi: We need to update existing records in Creator from records in an Excel spreadsheet. We see how to do this using the Migration tool, but the problem is, we are on a Mac. Is there another way to accomplish this? As presented from another post, here's the functionality we're looking for: 1. If the keys match, we would like to update/overwrite all the fields in the corresponding record using the Excel sheet data. 2. If the keys don't match, we would like it to create a new record and populate it
What is syntax for adding a CRM field into Creator
I'm trying to fetch the email from the CRM field into Zoho Creator form. can someone help me with the syntax to be used for fetching records from CRM to creator. Thank you.
Export Excel Workbook with multiple spreadsheet tabs
Is it possible to export Excel Workbook with multiple spreadsheet tabs?
Alert or a Pop up after on click submission
Dear Sir / Madam I have created a form, where user having facilating of deleting a record, But I want before deleting record, user must get an alert or pup up box which shows "Are you really want to delete ?" On user confirmation only record can delete. i.e I need a double confirmation from user before record permanently delete. Could some body tell me how I use this functionallty on "On Click" Option.
Sticky search panel
Hi, While I'm developing a Creator app, I see my colleagues using a lot the search panel available in Report page. I see they are struggling when they are narroying a search. It would great to have a "Leave search panel open" button (or similar), so the panel stays open, until they they want it closed. Regards
Cannot find parent ID in a subform
I have a subform that is linked back to its parent form by ID. Although the ID and other fields of the parent form record could be presented in reports, I cannot find the ID (the foreign key) when trying to reference it from another form. I can create a new field that copies the parent ID form but this would be a redundancy. Any other solutions? Regards
Filter subform records and autopopulate a subform field
I have a pretty simple setup with two forms. There is a Projects form (parent) and a Tasks form (child). The Tasks form is used as a subform within the Projects form so that each project record can show multiple tasks associated with that project, and tasks can be added and edited from within the Projects form. This mostly works with the following two issues: 1. I want the Tasks subform to display all of the Tasks records that correspond to the current Projects record. The Tasks form contains
Format zoho.currenttime?
Is it possible to format the output of zoho.currenttime? For example, I'd like to take... 24-Apr-2012 11:45:28 ...and show the output as... 04-24-2012 11:45 AM Thanks for any help!
Share/Invite not working
Hi, My client invited me as Developer for his app. But, I didn't get email. When I check my Home page, I don't see that app. My account is in the domain "creator.zoho.in" My client's account is in the domain "creator.zoho.com.au" Is that an issue?
quick question re: api call by url
Can I make an api json call with the following url instead of via a form element as laid out in the docs here: zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html ? creator.zoho.com/api/json/<ApplicationName>/view/<ViewName>?&authtoken=<myToken>&scope=creatorapi&zc_ownername=<myOwnerName>.json I'd imagine I'll also run into CORS problems. FInally, how do I add criteria to an api call like the one above? In particular, how to url encode a date field. ( e.g. &criteria=myDateField==12%2F14%2F2019
Syntax in deluge to reference a field in another application
What is the correct syntax to reference a field in another application in deluge script. e.g. recordToSelect = somehowReferenceAnotherApplicationAndForm[fieldName == "somethingSomething"].ID; Thanks! Brady
Subform Report Template
Hello, My data is recorded in subform and i want to print them as follows: Design No.: Shade No.: Meter: Design No. Shade No. Meter 56459 240 25.00 55830 210 50.00 23430 1 35.00 23437 2 35.00 what i want to say i want to make 2 columns
Hidding Print Option in Report Detail View
Hello, I have Report emmbeded in HTML Snippet on Page. I succesfully hide Print/PDF option in Quick View with Style URLs but i can't find any options for Print/PDF in Detail View
Unable to add new users
We currently have 17 users in our application. When I try to add a new user, the pop-up dialogue states that we have reached our limit of 19 users and will need to pay to add this user. Any ideas how I could fix this?
Preventing users from office A viewing reports from office B or vice versa
I have only 1 form for data entry that is accessible by office A and office B. One of the fields is the Office Site where users select from the dropdown either office A or office B. I would like to prevent users from office A seeing data entered by users from office B. How do i achiveve that?
2020 Wish List for Creator
Seasons greetings! Dear great Zoho team, here are my top 5 enhancements to Creator for 2020 Give us some formatting options on List Reports especially on headings - word wrap especially Give us some more styling options on Form designs. They are ugly today The ability to customise Alert and use in all locations. Alert (warnings, error, information) different colour different icon On Workflow list, show modified date (not added date as if I am modifying 100 scripts I need to know when they were last
How can I launch a bulk edit action by a custom action (how do I write the URL)
How can I launch a bulk edit action by a custom action (how do I write the URL). And how can I manage the information shown on the BULK EDIT window. Like I want to the give the choice to edit just one column. Thank you!
Update Aggregate Total
Hi, Firstly apologies if this is something simple but I can't seem to get the workflow to work. I have two forms. Form A - Kits Form B - Assets Multiple Assets can be added to a single Kit. Joined with Lookup fields. Each Asset has a rental value (FormB) which by using an aggregate workflow in form A calculates the sum of all Assets and adds a value to a total field in form A. This all works as it should and gives the correct total. The problem is that if I update the rental value in Form B the
Sent emails in MS Outlook
Hi, I want to see the emails sent via ZOHO Creator app in my MS Outlook's sent item. Is that possible?
Create a custom function in ZOHO Creator using deluge script
Create a custom function in ZOHO Creator using deluge script : You can create custom function using deluge script in ZOHO creator app. Please follow below steps to adding a custom function...
Audit Trail - search by login ID
Hi If we are using an audit trail to view changes to records, it would be useful to be able to see what a user has done by searching their login ID, rather than just the unique ID of the field.
My Creator API Get response gives me a 200 result but no records.
Hi! I'm making a GET request as follows: https://creator.zoho.com/api/json/medlemsregister/view/Medlemmar?authtoken=XXXXXX&scope=creatorapi&zc_ownername=Erik.Ekblad note: authtoken is hidden above. The response code is 200 but the output is empty. I have currently 3 records in the view. What am I missing here? Thanks! Erik
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?
Test for blank 'Time' field
How do I test for a blank time field in script? The below doesn't seem to work, I've also tried the isEmpty() function, and == "" with no luck. It does work with date fields, so i would assume it would be the same? If (time_field == null) { time_empty = TRUE; } Thanks
Pass URL parameter to a function. Not work in mobile application
Through the url I pass a parameter to a page that contains buttons. The buttons executes a function for which the parameter passed through the URL is required. If I do it on desktop it works perfect. In the mobile application argument of the function = null. Why is the parameter lost along the way? Any solution...
API Lookup Field Criteria Broken
When selecting a record to edit using a lookup field value, all I got was "Failure, No Records Found With Specified Criteria.". I've double/triple/quadrupal checked my lookup field name. Adding records via the API with the lookup field name and criteria value is fine.
Get rows and send Email
How i can import some rows to zoho creator and send these rows by email to a specific user. I made this but send separated emails by row. I need to group all rows and send as list or some other option but in ONE email. Is this possible with zoho creator?? data = Invoice_Tracker[Fecha_Emision == "02-Oct-2019"].Folio_Dte;
sendmail
[
from :zoho.loginuserid
to :"xxxxxxx@gmail.com"
subject :"lista facturas"
message :data
]
Displaying All Fields in a Subform When Viewing Report
I have created a form that is going to be used to track employee goals. The form itself has information about the employee and manager, and then there is a subform field that is used to list individual goals and related information about each goal. When setting up the associated list report, I checked the box "Create a link to show all fields," for the subform field which then creates a hyperlink for each goal in the report, that when clicked, is supposed to show all the information about that goal.
script issue
Hello, I met an interesting issue today. I had a script in one of my apps which has worked fine so far...nothing has changed as far as I know.... Here is the script: input.Purchase_status = "sztornózva"; storno = insert into Purchase_form [ Added_User=zoho.loginuser Supplier_name=input.Supplier_name Invoice_number=input.Invoice_number Date_of_purchase=input.Date_of_purchase Net_total=input.Net_total * -1 VAT_total=input.VAT_total * -1 Gross_total=input.Gross_total * -1 ]; for each rec in input.Purchase_details
Performing a lookup and bringing in data from another application
Hi I have two applications; Roles and HR. When a Leaver form is completed in HR, I would like to pull data based on the Job Role Name in the Leaver form and add in Leavers_Instructions. So the list of Job Role Names is a lookup field from the Roles application. I am guessing i need to get the Unique ID for the Job Role I need and then use that unique ID to pull the Leavers_Instructions value. How would I do this??
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.
Building an app for my company
I would like to create a simple app for our company, that our customers can use. I already have a Google Developers account. My question is: I was searching Zoho , and all I can find is "Forms". ''I want an app that has "Icons" that my customers can click on. Is this possible?
Zoho Creator Single Select Field
Hello everybody I'm looking for a way to create a selection list where I can specify the options, no options that have already been selected should appear in the list. It is about documenting IP addresses. We have a pool of IP addresses. As you can imagine, IP addresses must not be used more than once. If a server has already been assigned an IP address, we don't want the IP address to be available for selection when adding a new server. Is such a thing realisable? Best Regards AINDER
Next Page