Column totaling
Hi Is it possible to sum the total of a numerical column in a report?
lookup
Hi, I have 2 forms 1st is match fixtures 2nd is corner statistics match fixtures form has match fixture id match fixture date corners form has corner statistics id match fixture date lookup home team i am trying to populate the home team based on the lookup field of the fixture id thanks
Creator 5 Panel Configuration
In the New Creator I am creating a dashboard that includes panels. They are created, and now I want to link (Action) the panel to a report. I have that all set and now I am at the Query Parameters point. How do I write this so it goes to the report and fetches my info? (ex: Status="Open") ??
Adding new records from another Form via email
Hi, As a workaround to the issue of Insert scripts not triggering Zapier actions, I'm trying to update a form with data from another form via email as suggested by Damien in this post: https://help.zoho.com/portal/community/topic/trigger-zapier-on-deluge-insert-into-function but unfortunately I can't seem to get a syntax that Deluge likes. I've checked the form email address and template I'm using and both look ok. Here's the Insert function I currently use that works (but doesn't trigger Zapier)
Get Record ID - Send Email
I'm trying to send simple email with an attachment from Parent detail screen but facing issue on getting record id. I have created two forms Parent Form and Child Form (contains look up of Parent Form). Created one send email button (custom Action) to send an email. i'm able to send email from parent but now want send email with an attachment contains all its child records as an PDF. Can someone please guide me on the same?
Zoho Creator Workshops 2018 - Around the US in 11 days
Hey all! Hope everybody's having a great week! I'm happy to announce that the Zoho Creator team is doing a Roadshow around the US to conduct training workshops, helping people build their very own apps. The events will take place across four US cities over a period of 11 days starting from August 20. Here are some specifics. Los Angeles August 20 - 21, 2018 Link: https://events.zoho.com/CreatorWorkshop-LosAngeles Chicago August 23-24, 2018 Link: https://events.zoho.com/CreatorWorkshop-LosAngeles
Creating a Custom Filter for a report to show a teacher all of their enrolled students
I'm looking to create a dashboard where Teddy Teacher can see a report of all of his enrolled students. Student Name Sally Student Class Name Reading Email Address SallyStudent@school.com Teacher Name Teddy Teacher Class Name Reading Email Address TeddyTeacher@school.com I'm creating a page in Zoho Creator and using the Report Widget to create this report. How would I write the filter?
Updating multi select fields on load
Hi Zoho, I'd like to update the options in a multi-select field on form load, how can I do this? Thank you Ravid
Shift planning
Hello, I hope someone can help me. I try to make an shift planning Application. It should be as easy as possible. So I want to have one Form with the folowing Fields: -Checkboxes for Weekdays -Date from -Date to -Time from (Dropdown with Times like 10:00, 10:15, 10:30...) -Time to (Dropdown with Times like 10:00, 10:15, 10:30...) The Goal is that we can enter for example evry Friday and Saturday between 01.06.2018 and 31.06.2018 from 10:00 to 19:00. In another Form there should be createt a single
Use decision field to trigger add records workflow
I would very much appreciate help with the following: I have two forms: Inscripci_n and Movimientos. In the form Inscripci_n there is a decision field (Julio 2018). Whenever this field is ticked I want this action to trigger an "add record" type workflow with the following info: Cant_Cargo in Movimientos has to equal Cuota_mensual in Inscripci_n and Conc_cargo in Movimientos has to show "Julio 18". This is the script I've come up with so far: if ( Julio_2018 == True ) ; { insert into Movimientos
Update Contact Person in Zoho Invoice
Hello, I’m trying to update the contact person in an invoice in Zoho Books using Zoho Creator. No I’ve written the following script but I still get the response: Bad JSON format/request etc. What am I doing wrong? The script is: contactpersonlist = list(); contactperson = Map(); contactperson.put(1,957028000001488016); contactpersonlist.add(contactperson); response = zoho.books.updateRecord("invoices","<orga/id>","957028000001529129",{"contact_persons":""+ contactpersonlist +""}); input.Response
Change to Open URL?
I have a custom action set up for each record in a report to print a page with information about the record. The custom action triggers a function that uses Open URL task to open a window with the information. The URL: openUrl("https://creatorexport.zoho.com/petersonenstein/tcb-frozen-samples/print/Sample_Request_Pick_And_Pack_Sheet?ReqID=" + ReqID,"new window"); This worked for the last 2 years and now all of the sudden when we click on the custom action nothing happens. Help! Peter
Lookup to same form?
Hi Zoho, I'd like to have a lookup field to pick a value from other entries of the same form (currently this is working only for fields from other forms) Any suggestion how to do this except having a drop-down population each "On Load"? Thanks Ravid
How to check an Email Address has been used when a form is submitted
I have a forward facing form and I want previous customers to submit feed back. I want to run a Validate on Submission to see if an Email Address is in my customer data base and if so to allow the submission. If not to deny it. I'm confused on how to construct the code; do I treat it like a string or a list/dropdown? both? Please let me know if you need any addtional information.
Send email with record summary as PDF attachment
I want to create a sendmail function that includes a record summary attached as PDF. My current code is: sendmail [ from: zoho.loginuserid to: input.Email subject: "Email" message: "Email" Attachment: template:OSClientes(Record Summary name) as PDF ] } Thanks in advance
google calendar invite notifications
Hi - I've successfully used deluge to create a google calendar event. https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html However, it just shows up on my calendar without seeing the notification in my inbox. I need people to see it to respond. This is especially important because some of my participants are outside my gapps domain, and as you know it won't create the event unless it's on a google calendar. Per this google page: https://developers.google.com/google-apps/calendar/concepts/reminders#overriding_default_reminders
Creator big files integration ?
I do not figured it out by now, how you can connect Zoho Creator with some file services like Google Drive or Dropbox. I am working in a small company with not so much users <10, so the free 5GB for files are a bit limited. Unfortunately we handle a lot & bigger files for large format printing. So this quota could be easily reached sometimes in 2-5 months. Perfect would be in total around 200-400 GB. Even if Zoho wants that every one is using Zoho Docs how can there an integration been achieved?
postUrl crashes when service returns error 500
Hi, I'm seeing a lot of postUrl-issues here. So I'll add mine: When doeing a postUrl, and the service returns an error 500, the script stops running with an Execution Failed / Error due to - 'Internal Exception' Line:(38). Viewing the returned data in soapUI, it shows that the service returns HTTP/1.1 500 Server Error, along with a XML messages, containing the error message. Apparently, ZOHO does not know how to deal with these kind of messages and at that point the script crashes. For no good reason.
Only allow submit if subform rows added
In a main form I have a numeric field. I would like to require user adds the same number of subform rows as the value of this field. For example, if the number field value is "3", there must be 3 subform rows added to the main form before user can submit. Is this possible?
Need Help with Conditional Formatting
I am having problems with conditional formatting on Zoho Creator 5. Everything works well on the computer but on the phone or pad it doesn't seem to work. What I need is to be able to see conditionally formatted colors on the quick view. The only thing that has worked is Calendar>Design>Quick View>Layout>Conditional Formatting>All Records. This will turn all my records into one color. The Selected Records formatting does not work at all as far as I can tell. This worked in C4. Is this a known
Writing Custom Filters for Zoho Creator Page/Dashboard
I'm looking to create a dashboard where Teddy Teacher can see a report of all of his enrolled students. Student Name Sally Student Class Name Reading Email Address SallyStudent@school.com Teacher Name Teddy Teacher Class Name Reading Email Address TeddyTeacher@school.com I'm creating a page in Zoho Creator and using the Report Widget to create this report. How would I write the filter?
Importing data to a subform?
I have a link to the old help page on sub form import/export https://www.zoho.com/creator/help/forms/creating-subforms.html#Import_Subform_Data Is there a new help document for import/export of subforms in Zoho 5? I was hoping just exporting some dummy data as Excel from my report would produce an example of what my mutl-sheet Excel should look like for import ... but I just get the subform information inside a cell as comma separated info, no second sheet to help work out what to do. Regards, Peter
Assign different labels and values to dropdown items
Is it possible to assign a value that's different than the label displayed to the user? Specifically, I need to pass on some values to an API and they need to be in a specific format. For example, in a dropdown for form of payment, if the user selects Credit card then the value passed on to the API should be credit_card. I would prefer not to display the dropdown items like this, only pass the correct values. The only way I can think of is with a variable and an if statement. If user selects Credit
Set Lookup value from Single Line input value
Hi, I wonder whether it's possible for Lookup value to mirror value filled in Singe Line value ? I'm trying to build a lookup function for certain value, it works, but when I fill the data, it shows all the records which will contain private information and based on information I got, we can't hide the shown records. So I just wonder if Lookup value could mirror the Single line value while I hide the Lookup field. I tried using input.Lookup = input.Singe_Line; but doesn't work because BIGINT and
Comments in Workflows
The new workflow builder is amazing! It would be nice though to have a notes field, so I can leave a comment like I can in deluge. Just like with code, it's difficult to remember why a particular workflow rule was put in place when you have lots of workflows. While it's great to be able to easily click some buttons to make powerful workflows, right now I have to keep a separate document that tells me what the reason was that I put the workflow in place.
Writing Custom Filters for Zoho Creator Page/Dashboard
I'm looking to create a dashboard where Teddy Teacher can see a report of all of his enrolled students. Student Name Sally Student Class Name Reading Email Address SallyStudent@school.com Teacher Name Teddy Teacher Class Name Reading Email Address TeddyTeacher@school.com I'm creating a page in Zoho Creator and using the Report Widget to create this report. How would I write the filter?
Filter a report
I have a table of employees that includes their login email address and a field that indicates if they can see confidential information (Yes/No). I have a report with each record marked if it contains confidential information. When a report is opened I want to show only records that are non confidential unless the employee is allowed to see confidential information. In creator version 4 I would use a custom action that fetches the employee record based on the login ID. Then an openurl statement
Insert Into Function with a Lookup Field
Hi - I am trying to create a new record in Form B when someone adds new information to Form A. However, one of the fields in Form B is a look-up field from Form A. Specifically, Form B has a customer look-up from Form A...when I update some customer info on Form A I want to use the "insert into" script to post a record to Form B, including the customer name I know how to do a collection variable to pull data from another form, but this seems the reverse since I am writing to another form that
Show image when select a product.
I'm trying to show the image in my field image when I select the product. I insert this code into my Product Lookup. //Fetch Product Record product_info = Products[ID == row.Product_Name]; /*Image field has two types of output when queried through the script. The uploaded file doesn't return the correct script like the one that was stored with the link. So, there is an additional script involved to get the correct image URL*/ //Remember, Product_Image used below is the Image field's deluge name
Working form now suddenly broken- (mismatch data type ...)
A form that has been working for over a year is now showing this error: Mismatch data type for function days360 at argument index 2 expected data type [TIMESTAMP] found dataType STRING Line:(1) Do I need to rewrite my app or is this an error on Zoho's end?
Replacement for JavaScript in HTML Pages
Dear Zoho Experts and Support team, In the implementation of HTML View, many time there is a need raised to use JavaScript, but as Zoho Doesn't support it So I want a replacement for this need, I am used many tricks, like advance CSS3 Animation but i think Zoho also gives a limitation to use CSS3 animation, and the second limitation to use CSS3 type animation is to it is increase the lines of coding, a typical simple CSS3 Animated Image slider will take almost 700-1000 lines, So It will be take
Calculating A Timesheet Jobs Total Hours & Comparing To Quoted Hours
(In Another Application)
Hi, I was wondering if someone could help me with this problem. I have had a look through the forum but no luck with my request. Let me explain what I have. 1 - Timesheet Application 1.1 - Timesheet Form (records hours users have spent on job. Example: 123 Test Job | Jack | 3 Hours 123 Test Job | Tom | 4 Hours 345 Another Job | Jack | 2 Hours 345 Another Job | Tom | 1.5 Hours 1.2 - Timesheet Report (Shows jobs and the total amount of hours spent on this job by different users) Example: 123 Test Job
fill in web page fields
I need to fill the fields of a web page with the data in my database. how can I do ? I hope I explained myself.
Add subform filtering to Print Template
Here's a proposition that I think could be very useful. Please see attached picture. I have a mainform "Venue" that includes a subform "Ressources" where I display the material and electric ressources needed for that venue. Material and electric ressources are both stored in the same form, for easier data entry and management, but when it comes to printing the venue's datasheet, it would be much easier to read the data if the material and electric ressources would be displayed in different tables.
Placing Reports under a folder in Creator
Hello All, I am fairly new to Creator and trying my hands on custom app development in C4. To begin with I had looked at Zoho CRM and wanted to replicate some of the UI aspects in the custom app that I build - in that aspect, I am looking for a way to group related reports under a folder, similar to how its displayed in the CRM module but unable to find an option. Could someone please guide how it is achieved in CRM and how it can be replicated in Creator. Thanks for all the help. Sowmya
Populate Form from other Form using Schedule
Hi, I'm trying to populate a form with data from another form using a Schedule function but can't seem to get a syntax that works. I have the following: Form = Job_Details Field = Location_ID string Field = File_URL URL Form = Site_Documents Field = Folder_ID string Field = Folder_URL URL Field = URL_Transferred Decision (true) I have a report based on Site_Documents that filters the records by URL_Transferred = false and if I edit any of the records individually from that report I have
Populating URL with record ID
Hi Guys, I am seeking your assistance, I Have two forms “FORM_A” and “FORM_B”, and need to create a function on the report of “FORM_A” to open “FORM_B” and populate one of its fields with the selected (clicked) record ID from the report of “FORM_A” So far, I have been able to create a function to call a URL to open a form “FORM_B” and populate “FIELD_1” with a fixed value (code below); what I’m actually after is to have “FIELD_1” on “FORM_B” populated with the selected record ID from “FORM_A” report
Export master and subform data to one spreadsheet
Hi all, I have been trying to get the URL based spreadsheet export functionality to include both master and subform data in a single workbook, using... https://creator.zoho.com/<username>/<appname>/xls/masterform_Report/exportDataDisplay=false (described here: https://help.zoho.com/portal/en/community/topic/export-master-and-sub-forms-to-one-spreadsheet) ...but it doesn't seem to do anything. Any idea how I can get all the data exported to a single spreadsheet? Regards, Will
Sorry, we are unable to regenerate the report
Hello, since a few days ago the pivot chats do not regenerate covering the message: "Sorry, we are unable to regenerate the report" What is the problem? How do I solve it?
Multi-select lookup -- keeping the order they were chosen in?
Hello I have a multi-select lookup to a list of features from which I would like to choose. When I add more than one item from the list, they get displayed in the order they appear on that table (rather than the order I selected them in). For example ... my feature list contains -- A feature -- B feature -- C feature When I add these to my product form using a multi-select lookup I want to be able to select them in the order I want ... like B feature, C feature, A feature --- although I do not have
Next Page