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
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. Tom
Default Contain value on Field filter in Report
Hy, When we open any Report and click on Filter then all fields shows on Right Side. and when we click on any field then it shows like FIELD NAME and below IS (in drop-down) , i need in place of IS it shows CONTAIN . Is that Possible? if yes then how?
Introducing InteGreat: A dedicated series on Zoho Creator Integrations
Hello everyone, We hope everything is going smoothly with Zoho Creator. As promised, we're back with another helpful community series, InteGreat. In this series, we will take you through the different steps involved in integrating your Zoho Creator application with any other service, be it a Zoho product or a third-party service like QuickBooks, Zapier, or PayPal. We'll pick from a list of popular integrations, and each post in the series will focus on a different one. If you have any suggestions
Is Zoho Creator C3 Server is down?
Is Zoho Creator C3 Server is down? no responding, C4, C5 works fine.
adding background image to panel not working
suddenly it doesn't work when i try to add a background image to a panel, i already tried creating a new app, and also with different browsers
Zoho Creator to zoho Books Integration
Hi, I am doing integration from Zoho Creator to Zoho Books. I am able to add records to Zoho Books - Items module when a record is created in Zoho Creator. However, I am not able to search the records from item module. I want to fetch the records using item name and get the id of that item and then in next step update the item details like price and unit. Below is the deluge script i have used but, I am not getting the correct output. Products is a lookup in the stock form. I have used below script
Sum values based on distinct value of another column
Hello, As an example, I am trying to add up the values in one column (Amount $) for each unique value in another column (Item No.) for each Company. Company Item No. Amount ($) A A100 17.60 A A100 17.60 A A101 18.00 B A102 25.00 A A103 17.60 B A104 12.00 B A104 12.00 The Amount ($) will always be the same for the same Item No. but a different Item No. can have the same Amount ($). I am trying to find sum(Amount ($)) but only for unique Item No. (i.e. only add once for duplicates such as A100 and
Entering data directly into Spreadsheet Report
Hello, I find the spreadsheet report very useful seeing that most of us are used to data entering on Excel. Is there an upcoming feature that will allow users to add new records directly in the spreadsheet view and also manipulate data just like in Excel (e.g. highlight, color, etc...)? I've seen other web-based apps that have this feature such as AirTable but I really want it to be implemented in Zoho Creator. Adding new data takes a lot of time especially if you have to access the form (importing
Migrating 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! - Sally
How 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 George
Combining 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. - Sally
Automatic form-filling for each user, if they don't do it themselves.
So I have an attendance form, wherein people mark themselves as present everyday while submitting the form. I want to write a deluge script in which if a user does not submit the form, the form is automatically filled for the user with the status field marked as absent. So far, I understand that it will be a scheduled workflow based on an hour of the day, where if the script does not find an entry for a user on the current day, a form will be auto-filled for all the relevant users with the status
Compare two lookup lists
What is the best way to achieve the following: (a) I have a data inventory form, and each record tells me whether a certain assurance activity should be undertaken by the data it holds. For instance the data says a special audit should be undertaken. (b) I have a second form which details the special audits that have occured. As an audit can cover multiple data inventory records under (a) the ID's of the records from form (a) covered by the audit are recorded as a list on form (b) - call it b_in_scope_records
Deluge Scrip Zoho CRM and Creator Integration
I'm attempting to write a simple script to pull data from Zoho CRM (Potentials) into a Creator form. Note: I want to pull all data from all fields and display those in Creator. I'm using the following script, and I'm getting the error below when I run the application. Thoughts from the community. contact_map = Map(); contact_map = zoho.crm.getRecords("potentials"); input.Test_App = contact_map.get("Created_By"); Error details: log messages Invalid client task found corresponding properties Line:(3)
Lookup field point to address field show multiple entry of the same value
Hello guys I have a vendor form with the address field. This form have multiple vendors on the same city, so the country, state, and city are the same for many of them, only the street change. Let's say I have 10 vendors in Canada, and 5 in Australia If I create a lookup field that point to that form and to the address field, I have a list of addresses. If I remove all the fields and choose to show only the country, of course I will have a dropdown that show the word Canada 10 times. How can I show
Hide/Disable Lookup Field Values
Hi, I have Form A - Employee Self Appraisal Form and Form B - Manager Appraisal Form. Form A - Employee Self Appraisal Form will have all the fields like Employee_ID, Employee_Name and Self Appraisal as text field entered by employee. Form B - Manager Appraisal Form will have Employee_ID field as lookup field which helps to auto-populate Employee Name and Self Appraisal field. Now Manager will look at the data fetched against each value from lookup field and adds his comments in comment field. Since
Delete files from "My Library" in page builder
According to this help article https://www.zoho.com/creator/newhelp/pages/configure_image_library.html it's not possible to delete files once they have been uploaded to the image library. I'm tidying up an app and want to delete some images. Can this be done somehow in spite of the bizarre statement that it can't be? Thanks!
Whatsapp Integration
Hello, Is it possible to integrate whatsapp with application on zoho creator?? Thanks & Regards
creating a list report
Hi, My customers give their orders on weekly basis. I'd like to create a list of those customers who have not ordered yet. Anyone could help me how to do that? Kind regards George
Add approval process from workflow inside forms or reports field
How to add/Enable approval process inside zoho asset tracker Work flow .As I can not able to see inside workflow.
Display fields in Zoho Creator from Zoho CRM
I would like to populate a database in Zoho Creator with fields from Zoho CRM. I know I can include some standard fields through the "Integration" but I have other customer fields in CRM that I would like to include in the database. I would like to display these fields in a report and trigger workflows based on fields changes (in Zoho) which would also change Creator. If deluge is required, syntax would help as I'm not a developer.
Using 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 there
Problem Adding SubForm rows via script
Hi there, I am having problem adding SubForm row via script. Scenario : Create_Hotel is the main form 1˚ subform : Create_Season (each row is a season, like "low season from... to...", "high season from.. to..", etc.) 2˚ subform : Create_Rooms (each row is a type of rooms in the hotel and for each type of room I have to copy in the field Create_Rooms.Season_room the value from Create_Season.Season. Same for Create_Rooms.rate_from=Create_Season.from and Create_Rooms.rate_to=Create_Season.to) the
Window type in Search element is changing automatically
Task 1: Created a Search Element in page. Did set a criteria in Filter Chose "Same Window" to open. Result: It was working fine. Task 2: Wanted to change criteria in Filter. Went to Search Configuration. Changed the Criteria in Filter. Problem: "Same Window" which I chosen previously is changing back to "New Window".
Best practice for tracking inventory
Hoy hoy! Question for you all, I'm hesitating between two concepts for tracking inventory and am wondering if anyone have an opinion on the subject. Doesn't really matter how the inventory is been changed (could be through a Sale order, a Shipping statement, a Balance Sheet, etc.), I'm more curious about what you think is the best practice. Option #1 Have a Product form with a field Inventory_Quantity When a product is been sold/bought/lost, etc. update the quantity field directly Option #2 Have
Next Page