Send an email to redirect to paypal payment.
Hello! I want to integrate Zoho to accept paypal payments. I would like to send an email that has data from a purchase order and in it, add a button with a hyperlink that redirects the payment of Paypal. Thanks!
Auto number with prefix and grouping
We're probably getting beyond Creator's capabilities but is it possible. We have a field in a table which first off pulls the "locations_room_ref;" from Locations table and concatenates a "/". if (input.devices_room != null) { roomid = Locations[ID = input.devices_room].locations_room_ref; input.device_ash_code = roomid + "/"; } We would LOVE to have the number sequentially increment after the "/" BUT the number to start from 01 for each locations_room_ref AND be unique - Note the same
"add record" to a form - and subforms!
Hi Zoho, Would appriciate help on this one: I have a form (Mainform) with two subforms (Subform1 ,Subform2). I need to use "add record" command to add a record to the main form - including data for the subforms (more than one row in the subforms...) How can I achieve this? Have tried to figure out the lookup solution discussed in this forum on earlier posts but did not succeed. Ravid
Field -> On User Input -> Add Record ::: not working?
Hi Zoho, I have a script running on user input in my form. It checks if the subform has a relevant record, if yes - the record is updated with the user input (working great), if not - it should add a record directly to the subform using bidirectional ID. but - the record is not added. Why? Thanks Ravid
Record Summart Printable Details
Hello, i need to create printable details view of the report, i have an example, but i cant make it how i need with multiple subform's. I add attachment's to images, how it should be, and what i get. Can anyone help me to figure out hot to make this? Thanks.
Subform fields in two colums under each other?
Van I place the fields in a subforrm under each other instead of next to each other? In two colums like this? Name Age Street Gender Postal code Country
my offline data?
how can I get my data that I capture using mobile phone which I capture offline?
Form not submitting on some cases?
Hi Zoho, I have a specific form (Import Data for on my app) that when checking some specific options on checkbox field, it is not submitting properly- I get a message that data was submitted, but the "On Success" script on On Add -> On Success is not processed- details that are supposed to be updated are not updated, and openURL command is not processed either, I stay in the same windows with the form reloading again. This happen 'hen "Section" field is filled with "Loan" and Insurance_Sub_Sections
Cascading dropdown
Hi, How caw ce create Cascading dropdown in the form ? Thanks for your help, Ugo
Trying to extract all the database from Zoho Creator
Hi ! I try to extract the entire database from Zoho Creator to reinject it into a Sql Database, but i can't find any way to do it in the documentation or on the forum.. Can someone help me to do it? Thank you and sorry for my poor english :)
How to enable/disabe field depending on a decision box.
Hi, I'd like to know how can I enable/disable form fields depending on if a decision box have or not been clicked, thanks!
Display HTML page of user data
I want to create a page that displays the information that a logged in user has entered using the Add_Student form. Each user will only have 1 record. Assuming that I need to use a parameter to pass the id of the logged in user, I created a parameter named user_id_param and set it equal to zoho.loginuserid. I also added a collection variable named s (s = Add_Student [User_ID == zoho.loginuserid];). How would I display the embedded Add_Student form already populated with the user's information on
add user in customer portal
hello, in my zcreator i have a form "CONTACT". Do you have a function to add a CONTACT directly in the customer portal without pass by admin ? thanks you
Can't Restrict Records by Role
Previously I was able to set reports up so that a User could only view the Records of people with the same Role. That no longer appears to be the case, and support is saying that feature never existed...but it has been like that for the past 6 months.
[Question Update a field in function of other field in real time
Hello, How we can update a field (Look up) in function of a radio button input in real time ? Thank you ! :) Josselin
Get most recent ID entered?
Hi Zoho, I have a script adding records to a form. in this script, after adding the record to the main form, I need to get its ID in order to insert data to its subforms using bidirectional lookup. Since the records are inserted automatically, it happens very quickly, so a fetch that is sorted by Added_Time does not work. I don't want to use fields entered by the user since they can be identical. Any idea how can I get the last added ID? the script look like this: for each EachIDforImport in Vals_for_Import_ID_List
delete record doesn't always work
Hi Zoho, I have a form with a subofrm in it. When I delete a row from the subform and submit the form, the row is deleted from the main form entry but stays in the subform report. To fix this, I have added a "delete record" script on "on delete row" for the subform under the main form, so on delete row it deletes it from the subform report too. But - this only works is some of the cases. If I delete a row, and than add another row or change data anywhere in the subform before submitting the main
customer portal
hi, in my creator i have a form "QUOTES" with the email of the company. The company has an access to the customer portal with the same email. i create a view on QUOTE with criteria (Email == zoho.loginuser) but when the company is connected on the portal she can see all quotes and not as his own. Other problem, if the profile CUSTOMER can have an access on QUOTE, the company can view all quote's reports Do you have a solution ? thanks you
How do you update a subform picklist, with values from rows in another subform?
I have created one form to gather information when on-boarding customers - one subform gathers information pertaining to user-groups, another gathers information about individual users. Each user can belong to several user-groups, which are created by adding rows in the user-group subform. How do I dynamically populate the picklist on the user subform with the information gather from each row in the user-group subform? I've tried a variety of solutions that haven't worked - the most logical one to
Need developer for Member Directory Project
Need to create a membership based directory. 2 member types (Basic and Premium). Multiple member characteristics fields. Basic membership is Free and member can only add and update their own profile. Premium membership is chargeable on annual subscription and can perform searches for data in any field in the Basic member profile. Basic member profile must include links to member social media sites as well as incorporate custom code to retrieve the members social media follower counts for each
Add commas to the display of numbers in input fields in forms, once they are input
This seems straightforward enough - all spreadsheets do it! When I have entered a number in a numerical field of any sort, and hit tab or click in a different field, the number I just entered should display with commas, so I can easily see that what I entered is correct. The only way to get this kind of functionality now is to put a lot of code and additional fields around a single-line text field to make it pretend to be a numeric field for input purposes.
[Help] Decrementation of variable
Hello, I've create a form to save date. It's for administration, In new form client can select a date from save data of first form. I want create a field "Quantity" in administration form. And in the client form i want decrementation the quantity and if she is"0" the date is hide. Have a tutoriel or an idea of it will work ? Thank you, Josselin
Email
Would it be possible to set a "send mail" "on submit" and the somehow from a response change a field in a report. E.g- The statless form contains- Badge Number(look up field), First Name, Surname( both autopopulate on user input, Accept or Denny drop down. When click submit it sends an email to the person who has been selected, in this mail the person recieving it has the ability to respond accept or denny. from there it would show what they chose. Any suggestions on otherways to do this would be
What HTML editor have you been using for creating page layouts to use in Creator?
For those of you using an external tool to create the layouts for your HTML pages in Creator, which tool have you found to be the best for this use? My HTML is rusty & pages just aren't as user-friendly to create as everything else is Creator.
Subform formatting
Is it possible to change the colour of a subform header or remove it completely? Thanks Sean
Updating a Status Field
Hello there I am trying to get my <Status> field to automatically update to [Historical] after a selected period of time - taken from the <Date of Next Check> field. Does anyone have any ideas ?!? Many many thanks. Karen R
Urgent: Uploaded File Download URL / Link
Hello, Can someone please help me figure out how to construct the link for an uploaded file through a zoho form? I have found the following but it will not work for me. More specifically I do not know what the ViewLinkName is http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName I just want to email the link to public users (not logged into zoho) and allow them to download the file. Thanks
Update a record with subform?
Hi Zoho, I'm trying to user the "Update record" command. How can I update a subform? it is not listed in the fields list. Ravid
Updating a dropdown list
I have a file containing 70,000 records - product names, pack sizes and pack costs, which is updated outside of zoho creator weekly. I have imported the first file into zoho creator which is used in a form with a dropdown field "Product name". Once the product is chosen it fetches the corresponding "pack size" and " pack cost" in the non editable fields. I would like to import a fresh price list file into my Creator app each week which overrides the existing file without affecting existing records.
Flight Search Form
I need to make a flight search form where someone can select a 'From' destination and a 'To' destination and then return the search results after searching the schedule (which I have as an .xlsx). I can make the form easily though. Can I get help please?
Programatically update multi-select lookup field
Multi-select lookup fields are represented by bigintlist. However, there is no add() or insert() function to programatically update the list. How am I supposed to modify the list? There is a intersect() function on list but not union(), which would allow me to merge two lists together. That's another useful function. Help please!
Zoho Creator emails not working well (50% hit rate)
Hi, I have a Creator app which send about 200 emails a day to various parties. For the last 5 days the emails have simply not been sent - about 50% of them. This may relate to a black listed server?? Do anyone else have similar problems??
Fully authorized user can't see certain reports!!!
Notice in the screenshot there are two users. lexshan8 (me) and andrew.raymond they both have the same access Role and Profile. I specifically shared the entire application (Settings->Share->Invite, selected the root component, all sections, all reports and all forms) to andrew.raymond How come he still can't access the Orders - BO report? It's not showing up on the navigation menu at all. In fact, none of the Order related reports are showing. However, he can create new Order form. Totally weird.
Call export to spreadsheet from a function
Is there a way to call the export to spreadsheet command, based on criteria, from a custom function? I have a form with a field called Print_Label that is either True or False, default being set to True. I need to export all records where Print_Label is True to a spreadsheet, then set the Print_Label field to False. The later is easy to do with a function, but I don't see a way to trigger the export to spreadsheet option, or to do so based on criteria.
zoho creator errors
zoho creator is poping up errors in the Line -1 can any one help me out as i dont know where is line number -1
Null Error
I wrote the following very simple code to add a form and it is giving me a null error. Does anyone know why? form Opportunity { Displayname = "opportunity" success message = "Data Added Successfully!" field alignment = left Column { name ( displayname = "Name" type = text width 200px ) address ( displayname = "address" type = text width 250px ) amountowd ( displayname = "amount owned" type = currency width 200px ) actions { on add {
Record summary fonts
HI I am trying to desing a record summary but I need it to use a especifc font. (Boton). I put it in the HTML code of the section but it export other fonts to PDF. Any way I can do that? Regards.
Android Creator App Error
We have our entire team using android tablets to access the Zoho Creator app. A few people have iOS devices as well. This morning, all Android devices are coming up with an error when the app is opened. It just says "An Error has occurred." I tried to restore a previous version of the app with no success. The same error occurred. It asked to report the issue and I have. I checked our account and can't seem to figure out why it is happening. It is happening on mobile and wifi connections sop it is
Can we bring data into creator from a Zoho CRM custome field or module?
We want to use a form for reporting on our English classes. We would like to pull the information from CRM. Is this possible? We curerently are using the contacts for our students and accounts for the customer but we want to create the classes with their details in a custom module and then have a pick list in Creator to pull the info over.
Display Decision Box in View not as True/False
Is there a way when using a Decision Box to show this in a different way then true/false in a View? I would prefer to show it as "Yes"/"No". any suggestions how to do that? thanks Henk
Next Page